Home » Developer & Programmer » Forms » can i get the sql scripts when running a form?
can i get the sql scripts when running a form? [message #83667] Fri, 21 November 2003 16:03 Go to next message
ding213
Messages: 2
Registered: November 2003
Junior Member
i'm populating tables and doing queries by running a form. is there a way to extract the sql scripts (like: insert into table_name values....., select * from.....)
into a text file so that i can run them in sqlplus?
Re: can i get the sql scripts when running a form? [message #83672 is a reply to message #83667] Mon, 24 November 2003 03:14 Go to previous messageGo to next message
magnetic
Messages: 324
Registered: January 2003
Senior Member
yes, just copy/paste each procedure in a text file and rename it into *.sql and run it with sql+
Re: can i get the sql scripts when running a form? [message #83679 is a reply to message #83672] Tue, 25 November 2003 15:35 Go to previous messageGo to next message
ding213
Messages: 2
Registered: November 2003
Junior Member
but the problem is i don't know where to copy from. you mean copy from PL/SQL library module? i couldn't find the script i want there. i mean those inserting code, e.g.: "insert into table values(....)" .
i'm using oracle form 6i, could you pls tell me more details? sorry if the question seems simple, i'm a beginner.
Re: can i get the sql scripts when running a form? [message #83700 is a reply to message #83679] Mon, 01 December 2003 07:29 Go to previous message
magnetic
Messages: 324
Registered: January 2003
Senior Member
explore the form.
begin at when-new-form-instance to find the first procedure been called.
fallow the flow of called procedures/functions to find out where the inserts happen.
Previous Topic: FRM-41072
Next Topic: KLOC in forms 6i
Goto Forum:
  


Current Time: Sat Aug 13 01:33:32 CDT 2022