OraFAQ Forum: Forms » Dynamic SQL in Forms6i

Home » Developer & Programmer » Forms » Dynamic SQL in Forms6i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dynamic SQL in Forms6i [message #237899]

Wed, 16 May 2007 01:52

whoru
Messages: 5
Registered: May 2007
Location: Pune

Junior Member

Dear Sir/Mam

Please, help me for -
How to use dynamic SQL in Forms 6i.
I have not yet used it.

Report message to a moderator

Re: Dynamic SQL in Forms6i [message #237914 is a reply to message #237899]

Wed, 16 May 2007 02:23

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

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.

Report message to a moderator

Re: Dynamic SQL in Forms6i [message #237928 is a reply to message #237926]

Wed, 16 May 2007 02:45

prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune

Member

Sir,

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

Report message to a moderator

Re: Dynamic SQL in Forms6i [message #237933 is a reply to message #237914]

Wed, 16 May 2007 02:57

prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune

Member

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

Report message to a moderator

Re: Dynamic SQL in Forms6i [message #237959 is a reply to message #237933]

Wed, 16 May 2007 03:42

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

Report message to a moderator

Previous Topic:	Using Outlook Express in Forms 6i
Next Topic:	LIKE operator in FORMS6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 15:49:33 CST 2025