OraFAQ Forum: Forms » Pl/SQl codes for Exit form & Import/Export data

Home » Developer & Programmer » Forms » Pl/SQl codes for Exit form & Import/Export data

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

Pl/SQl codes for Exit form & Import/Export data [message #167407]

Wed, 12 April 2006 18:01

Rose_250
Messages: 17
Registered: April 2006

Junior Member

Hii,
I have 2 problems:
First, Exit form doesn't work unless you entered any field or the query is executed. The system gives me Alert that"Field must be entered". The code which i uses:
BEGIN
Exit_Form;
It is just working when you entered a field..
END;
Second problem:
I want to write codes that will enable me to import & export data from files, for example, in excel format, using PL/SQL. And how I can include them(import & export) in Menus.

Thanks for every body, helping us in sharing knowledge. .

Report message to a moderator

Re: Pl/SQl codes for Exit form & Import/Export data [message #167471 is a reply to message #167407]

Thu, 13 April 2006 04:19

RAS_SANKAR
Messages: 42
Registered: March 2006
Location: India

Member

1. u change the Required property to false or
write exit_form(no_validate)
2.search for this forum.

- Ras.

Report message to a moderator

Re: Pl/SQl codes for Exit form & Import/Export data [message #167487 is a reply to message #167471]

Thu, 13 April 2006 06:00

Rose_250
Messages: 17
Registered: April 2006

Junior Member

Thnx Mr. RAS SANKAR for your reply,

I'll be gladful if you can lead me to those links about Import/Export codes.. Embarassed

Thnx a lot..

Report message to a moderator

Re: Pl/SQl codes for Exit form & Import/Export data [message #167499 is a reply to message #167487]

Thu, 13 April 2006 06:55

RAS_SANKAR
Messages: 42
Registered: March 2006
Location: India

Member

try this
http://www.orafaq.com/forum/m/89755/84366/?srch=export#msg_89755

Report message to a moderator

Re: Pl/SQl codes for Exit form & Import/Export data [message #167504 is a reply to message #167499]

Thu, 13 April 2006 07:15

Rose_250
Messages: 17
Registered: April 2006

Junior Member

Thanx a lot Ras,

But what I actually want is how to write codes of import and export and then putting them in a Menu; because I am using Developer2000
(not a web based to use the given link )

Thnx a gain Ras..

Report message to a moderator

Re: Pl/SQl codes for Exit form & Import/Export data [message #167901 is a reply to message #167504]

Mon, 17 April 2006 21:29

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Search this forum for 'text_io'. Write your 'Excel' data as a CSV (comma separated values) file. If you MUST read an 'XLS' file then search this forum for 'Excel' and 'XLS'.

David

Report message to a moderator

Re: Pl/SQl codes for Exit form & Import/Export data [message #168043 is a reply to message #167901]

Tue, 18 April 2006 09:21

Rose_250
Messages: 17
Registered: April 2006

Junior Member

Thanx for your guidance Mr. David...

Report message to a moderator

Previous Topic:	Change User Password on Runtime
Next Topic:	determine mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 16 02:10:19 CDT 2025