URGENT! HELP! Variable Substitution in PL/SQL
From: KYLai <laiky_at_hkstar.com>
Date: 1996/10/04
Message-ID: <531ssm$l9t_at_capella.hkstar.com>#1/1
Date: 1996/10/04
Message-ID: <531ssm$l9t_at_capella.hkstar.com>#1/1
Hello!
I would like to write a procedure to check the existence of an element in the table(
input parameter : table name, field name, field value; output parameter : True - record found False - record not-found);
This procedure will be called by forms.
Can anybody advise me on the followings:
- how can I define the datatype of the input field?
it may be varies, may be VARCHAR2/NUMBER...
how can I make use of %type if table_name & field_name are
only known at run time?
- how can I substitute the table_name of the SELECT statement in declaring the CURSOR?
: I can't use NAME_IN function in SELECT statement
I am new for ORACLE. May anyone of you can share your knowledge with me, advise me how to solve the above problems.
THANKS A LOT for YOUR HELP.
Best Regards,
KY Lai
Received on Fri Oct 04 1996 - 00:00:00 CEST