Home » Developer & Programmer » Forms » How to pass parameter for table name in d2k form.
icon10.gif  How to pass parameter for table name in d2k form. [message #123429] Mon, 13 June 2005 07:55 Go to next message
bal_tan
Messages: 2
Registered: June 2005
Junior Member
Hi ,
I am facing the problem to pass parameter for table name in d2k form.
If any solution please infirm me earliest to my mail id.
(bal_tan@rediffmail.com)
------------------------------------------------
example:
begin
select ename into :ename
from :tab_name
where empno =7788;
end;
-------------------------------------------------
It gives error as bad bind variable 'tab_name'
*** where :ename and :tab_name are form fields

Thanking you,
Balasaheb
Re: How to pass parameter for table name in d2k form. [message #123604 is a reply to message #123429] Tue, 14 June 2005 02:24 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use dynamic SQL. Search this forum for 'dbms_sql'.

David
Previous Topic: ...Run Time Issue
Next Topic: forms 4.5
Goto Forum:
  


Current Time: Fri Sep 20 05:38:10 CDT 2024