Home » Developer & Programmer » Forms » Dynamic SQL in Forms6i
Dynamic SQL in Forms6i [message #237899] Wed, 16 May 2007 01:52 Go to next message
whoru
Messages: 5
Registered: May 2007
Location: Pune
Junior Member
Embarassed

Dear Sir/Mam

Please, help me for -
How to use dynamic SQL in Forms 6i.
I have not yet used it.
Re: Dynamic SQL in Forms6i [message #237914 is a reply to message #237899] Wed, 16 May 2007 02:23 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

welcome to the forum Cool

check this one.

regards
shanth

[Updated on: Wed, 16 May 2007 02:24]

Report message to a moderator

Re: Dynamic SQL in Forms6i [message #237926 is a reply to message #237914] Wed, 16 May 2007 02:41 Go to previous messageGo to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member

I really didn't get, what exactly you want me to check.
I am clickin on the word "one", & I am getting the same link which I get after clicking on the forums option.
Re: Dynamic SQL in Forms6i [message #237928 is a reply to message #237926] Wed, 16 May 2007 02:45 Go to previous messageGo to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member

Sir, Embarassed

I have used the following

execute immediate 'create table pg_emp as select * from emp';

But, it gives error.

Please, can you give me the code for it??

Thanks & Regards,
Prachi
icon12.gif  Re: Dynamic SQL in Forms6i [message #237933 is a reply to message #237914] Wed, 16 May 2007 02:57 Go to previous messageGo to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Cool Thnx,

I got the link.
First I was getting the wrong site opened.
Now I got it.

Thnx a lot.

But, I want to use dynamic SQL through forms.
How can I do that?

Please help.

Thanks & Regards,

Prachi Razz
Re: Dynamic SQL in Forms6i [message #237959 is a reply to message #237933] Wed, 16 May 2007 03:42 Go to previous message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

the given link was pointing to this content.


Can one execute dynamic SQL from Forms?
Yes, use the FORMS_DDL built-in or call the DBMS_SQL database package from Forms. Eg:

        FORMS_DDL('INSERT INTO X VALUES (' || col_list || ')');

Just note that FORMS_DDL will force an implicit COMMIT 
and may de-synchronize the Oracle Forms COMMIT mechanism


one more thing
just curious---the profile whoru and the profile prachi.mgorwadkar belongs to you??


regards,
shanth
Previous Topic: Using Outlook Express in Forms 6i
Next Topic: LIKE operator in FORMS6i
Goto Forum:
  


Current Time: Sun Dec 04 00:47:48 CST 2016

Total time taken to generate the page: 0.10070 seconds