[SOLVED] ORA-01008: not all variables bound

Discussion regarding installation problems for all products.

[SOLVED] ORA-01008: not all variables bound

Postby Andreasa » Mon Oct 17, 2011 2:57 pm

I get an error when I run this function:
Code: Select all
If Not SalTblPopulate( hWndForm, hSql1, sSQLStatement, TBL_FillAllBackground )
                Call SalMessageBox( 'Could not populate Work Order table', 'SQL Error', MB_Ok )

Error:
http://grab.by/b4Uu

Query sSQLStatement
Code: Select all
SELECT   W.WONUM, W.DESCRIPTION, L.LOCATION, L.DESCRIPTION, W.LEADCRAFT
INTO   :colWONUM, :colDESCRIPTION, :colLOCATION, :colLOC_DESCR, :colEIC
FROM   FMMV_WO W, LOCATIONS L
WHERE   W.STATUS   IN ('APPR', 'INPRG')
AND   W.siteid      = 'ELECTRIC'
AND   W.istask      = 0
AND   L.siteid      = 'ELECTRIC'
AND   W.LOCATION   = L.LOCATION
AND  W.LEADCRAFT   = :sEIC  AND  W.WOLO2   =  :cmbRespGroup


cmbRespGroup & sEIC have valid values.

Code: Select all
:colWONUM, :colDESCRIPTION, :colLOCATION, :colLOC_DESCR, :colEIC

are valid colums that I want to populate

I am out of ideas on why it is giving me an error. Thoughts?
User avatar
Andreasa
 
Posts: 45
Joined: Thu Aug 11, 2011 3:56 pm

Re: ORA-01008: not all variables bound

Postby Andreasa » Mon Oct 17, 2011 3:42 pm

Problem solve!!!
My user did not have enough permissions on the oracle table ... :x I wish errors were more friendly.. but this is oracle side.
User avatar
Andreasa
 
Posts: 45
Joined: Thu Aug 11, 2011 3:56 pm


Return to Installation

Who is online

Users browsing this forum: No registered users and 1 guest

cron