OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » ORA-01008: not all variables bound

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » ORA-01008: not all variables bound (APEX 4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01008: not all variables bound [message #542850]

Fri, 10 February 2012 08:10

balckbandit5
Messages: 104
Registered: December 2011

Senior Member

Hello

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

Report message to a moderator

Re: ORA-01008: not all variables bound [message #542855 is a reply to message #542850]

Fri, 10 February 2012 08:31

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)

Report message to a moderator

Re: ORA-01008: not all variables bound [message #542858 is a reply to message #542855]

Fri, 10 February 2012 08:44

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 19:55:46 CST 2024