Oracle Form-query from clause with parameter

Dear Expert,

iam working in oracle 10g forms,

I have 2 forms

1.calling form

2.called form

from calling form iam passing a parameter to called form

the parameter is co_id

from the called form iam catching the parameter :parameter.co_id.

And in the called form i have a block with from clause query.

Like select a.customer....

from table a,table b
...where a.co_id = :parameter.co_id

when i run the form

ORA-01008: not all variables bound

Please help me.
daprjoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

k_murli_krishnaCommented:
ORA-01008: not all variables bound
Cause: A SQL statement containing substitution variables was executed without all variables bound. All substitution variables must have a substituted value before the SQL statement is executed.
Action: In OCI, use an OBIND or OBINDN call to substitute the required values.

Also Refer:

PL/SQL ORA-01008 : Not all variables bound
http://www.dba-oracle.com/t_ora_01008_plsql_variables_bound.htm
http://dbmotive.com/oracle_error_codes.php?type=ORA&errcode=01008
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
flow01Commented:
did you define the parameter co_id in the called form ?
check if  :parameter.co_id  is really available in the form by
referring to it the when_new_form_instance trigger

begin
message('co_id:'  || :parameter.co_id);  

and compile the program-unit
0
daprjoAuthor Commented:
Yes i did still error is coming.Please help me.

THANKS&REGARDS
0
flow01Commented:
1) Did you get the error when compiling the change I mentioned
or
2  could you compile the when_new_form_instance trigger and did you get the error executing the form

ad 1) add co_id as a parameter to the called form
ad 2) i can't test for myself know if refering to :parameter.co_id in the where is not possible (i think it possible)
   but you can check it your self because referring to a control-item is possible:
   1. add  an item p_co_id to a control block
   2. in the when_new_form_instance copy the value
        for example :ctrl2.p_co_id := :parameter.co_id;
   3. change the reference in the where to :ctrl2.p_co_id
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.