Home » Developer & Programmer » Forms » Sql script in Form6i
Sql script in Form6i [message #192431] Tue, 12 September 2006 06:25 Go to next message
Messages: 16
Registered: October 2005
Location: Iran
Junior Member

Hi there,

I want to make a sql script file in Forms6i and then run it in Forms6i , too.

I want to make my script file by this query:

select 'grant '||privilege||' on '||table_name||' to USER2;'
from USER_tab_privs where grantee='USER1'

What can I do ?

Re: Sql script in Form6i [message #192574 is a reply to message #192431] Tue, 12 September 2006 21:32 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use the 'host' command to run the script on the server and then use 'text_io' to read it back. Search this forum for the keywords mentioned.

Previous Topic: Please help me to use client_get_file_name()
Next Topic: read data created of the file
Goto Forum:

Current Time: Sun Aug 20 12:30:53 CDT 2017

Total time taken to generate the page: 0.12405 seconds