OraFAQ Forum: Forms » How to use external Tables in Oracle Forms 10g

Home » Developer & Programmer » Forms » How to use external Tables in Oracle Forms 10g (windows 7... oracle forms and report 10g)

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

How to use external Tables in Oracle Forms 10g [message #510518]

Mon, 06 June 2011 06:19

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

Hi guys
I need your help
How i use external tables as a form datablock in oracle oracle forms 10g

an i use anyway external tables in a form datablock ???

Report message to a moderator

Re: How to use external Tables in Oracle Forms 10g [message #510522 is a reply to message #510518]

Mon, 06 June 2011 06:30

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

Senior Member
Account Moderator

Yes, you can base your block on an external table.

What would be its use, though? It would be READ-ONLY.

Report message to a moderator

Re: How to use external Tables in Oracle Forms 10g [message #510642 is a reply to message #510522]

Tue, 07 June 2011 00:39

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

yeah but how can i use this extenal table

can you send me a complite steps..how can i use it..

thanks in advance

Report message to a moderator

Re: How to use external Tables in Oracle Forms 10g [message #510650 is a reply to message #510642]

Tue, 07 June 2011 02:07

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

In exactly the same way as a normal table. Just create a block on it in the datablock wizard.
There are no special steps.
However you will want to set update_allowed and insert_allowed on the block to No.

Report message to a moderator

Previous Topic:	FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed
Next Topic:	FRM-91120 Internal ERror: Unable to load NLS character set

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 12 09:02:04 CDT 2024