OraFAQ Forum: Forms » EXECUTE IMMEDIATE( )

Home » Developer & Programmer » Forms » EXECUTE IMMEDIATE( ) (Developer 6i, 6, Windows Xp)

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

EXECUTE IMMEDIATE( ) [message #333643]

Mon, 14 July 2008 00:42

azamkhan
Messages: 557
Registered: August 2005

Senior Member

What EXECUTE IMMEDIATE() does?

Report message to a moderator

Re: EXECUTE IMMEDIATE( ) [message #333653 is a reply to message #333643]

Mon, 14 July 2008 01:27

Frank
Messages: 7901
Registered: March 2000

Senior Member

What pages did you read after you googled for it?
What exactly did you not understand?

Report message to a moderator

Re: EXECUTE IMMEDIATE( ) [message #333659 is a reply to message #333643]

Mon, 14 July 2008 01:33

Michel Cadot
Messages: 68693
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Regards
Michel

Report message to a moderator

Re: EXECUTE IMMEDIATE( ) [message #333666 is a reply to message #333643]

Mon, 14 July 2008 01:53

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

azamkhan wrote on Mon, 14 July 2008 07:42

What EXECUTE IMMEDIATE() does?

What this question has to do with Forms?

Report message to a moderator

Re: EXECUTE IMMEDIATE( ) [message #333668 is a reply to message #333666]

Mon, 14 July 2008 01:56

azamkhan
Messages: 557
Registered: August 2005

Senior Member

If this procedure can run SQL statments then I have a requirement that require to run dynamic sql statment that will be generated on runtime.

With the help of EXECUTE IMMEDIATE() I can run the sql statment process the result and perform my task.

Report message to a moderator

Re: EXECUTE IMMEDIATE( ) [message #333674 is a reply to message #333668]

Mon, 14 July 2008 02:14

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I see; however, consider the difference between use of the EXECUTE IMMEDIATE in SQL and Forms.

/forum/fa/4618/0/

Attachment: execute_immediate_sql.PNG
(Size: 13.07KB, Downloaded 5799 times)
Attachment: execute_immediate_forms.PNG
(Size: 16.98KB, Downloaded 6085 times)

Report message to a moderator

Re: EXECUTE IMMEDIATE( ) [message #333699 is a reply to message #333674]

Mon, 14 July 2008 03:29

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Thanks Michel Cadot you references where of great help.

Report message to a moderator

Previous Topic:	How to delete the record ?
Next Topic:	how to center the object when maximize?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 14:23:55 CDT 2024