Home » Developer & Programmer » Forms » execute an external .sql file from a Oracle stored procedure
execute an external .sql file from a Oracle stored procedure [message #114706] Tue, 05 April 2005 04:56 Go to next message
SushiDD
Messages: 1
Registered: April 2005
Location: Bavarian (Germnay)
Junior Member
Hallo,

i want to execute an external .sql file (eg, tab.sql) from a Oracle stored procedure. The sql-statements have to be contained in this file (!)
How can i execute the file or the content?

Thx!
Susann

Report message to a moderator

Re: execute an external .sql file from a Oracle stored procedure [message #114852 is a reply to message #114706] Tue, 05 April 2005 19:13 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have a look at UTL_FILE to read the sql and dbms_sql to execute it.

Report message to a moderator

Previous Topic: how to display two or more columns in a tlist ?help?
Next Topic: In which Font Forms Data Stored in DB
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:20:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.