Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » ORA-01008: not all variables bound (APEX 4.0)
ORA-01008: not all variables bound [message #542850] Fri, 10 February 2012 08:10 Go to next message
balckbandit5
Messages: 104
Registered: December 2011
Senior Member
Hello Smile

I'm getting this error on my tabular form...not sure what's wrong, its just a simple query:
select 
"ROLE_PERSON_ID",
"ROLE_PERSON_ID" ROLE_PERSON_ID_DISPLAY,
"MUID",
"ROLE_ID"
from "#OWNER#"."PMO_ROLE_PERSON"
WHERE "ROLE_ID" = :P12_ROLE


I ran it in SQL developer and it works fine (without "#owner#" but I've tried it in apex without that and it makes no difference)

and the error is
report error:
ORA-01008: not all variables bound

Re: ORA-01008: not all variables bound [message #542855 is a reply to message #542850] Fri, 10 February 2012 08:31 Go to previous messageGo to next message
c_stenersen
Messages: 255
Registered: August 2007
Senior Member
I'm having no problems, even if I use a non-existant item in the where clause. What happens if you remove the where clause? (Maybe your error is somewhere else in the settings than in the query itself)
Re: ORA-01008: not all variables bound [message #542858 is a reply to message #542855] Fri, 10 February 2012 08:44 Go to previous message
balckbandit5
Messages: 104
Registered: December 2011
Senior Member
It still doesn't work...which is strange because it worked fine before I added the where clause...

I just made the page again and its fine so don't know what settings I changed to make it do that...

[UPDATE]
Ok scratch that I do know what caused it, I tried to set a default value for the last column (ROLE_ID). Is there a way to do it?
What I tried was under tabular form attributes where it said default I just put in &P12_ROLE. and "ITEM" as the type...but obviously that didn't work...

[UPDATE 2]
Ok scratch that again, I got it (Put "P12_ROLE" instead of "&P12_ROLE.")

[Updated on: Fri, 10 February 2012 08:52]

Report message to a moderator

Previous Topic: Conditionally change the colour of the text
Next Topic: Layout of a report
Goto Forum:
  


Current Time: Thu Mar 28 06:53:50 CDT 2024