| about binding variables [message #84988] |
Tue, 18 May 2004 05:35  |
R.SRIDHARAN
Messages: 1
Registered: May 2004
|
Junior Member |
|
|
whether there is any possibility of binding
table name as a variable in oracle forms 6i
for DDL
FOR EXAMPLE:
forms_ddl('drop table (:blockname.variable)')
|
|
|
|
|
|
| Re: about binding variables [message #85000 is a reply to message #84993] |
Thu, 20 May 2004 00:49  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
FORMS_DDL will not work.
Make a Stored procedure with following code & call it in your form.
Procedure xxx (P_TNAME VARCHAR2,P_ERROR VARCHAR2)IS
a varchar2(1000):='DROP TABLE '||TNAME||' CASCADE CONSTARINTS';
BEGIN
EXECUTE IMMEDIATE A;
P_ERROR :='SUCCESS';
EXCEPTION
WHEN OTHERS THEN
P_ERROR :=SQLERRM;
END;
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
