| Oracle Forms 6i Button Trigger [message #78432] |
Sun, 24 February 2002 23:42  |
Greg Horton
Messages: 37
Registered: February 2002
|
Member |
|
|
Hi guys, ive just joined the forum and havent used one before - so please forgive me if i do anything wrong.
Im currently developing an Oracle form to do some basic datamining and have the following questions:
I have a button on one of my canvas's and when pressed i need it to:
1) Execute a SQL statement (possibly stored in a procedure) to populate a cursor.
2) Populate a designated block with the contents of this newly filled cursor.
Any feedback would be greatly appreciated. I have basic knowledge of forms and a reasonable understanding of oracle and pl/sql, so please be gentle with the level of techiness in your reply!!
Cheers, Greg
|
|
|
|
|
|
|
|
| Re: Oracle Forms 6i Button Trigger [message #81651 is a reply to message #78432] |
Sat, 08 March 2003 11:55  |
nisha
Messages: 14
Registered: February 2002
|
Junior Member |
|
|
hi,
can u tell me how could i issue DDL commands from a button click.
i wrote a when-button-pressed trigger, having a statement like this.
declare
sqltext varchar2 (100);
begin
sqltext = 'CREATE TABLE EMP AS SELECT * FROM CUSTOMERS';
execute immediate (sqltext);
commit;
end;
this wasnt working... something wrong with the execute statement. Or else am i wrong at all?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
