OraFAQ Forum: Forms » using UTL_FILE with oracle forms

Home » Developer & Programmer » Forms » using UTL_FILE with oracle forms

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

using UTL_FILE with oracle forms [message #206461]

Thu, 30 November 2006 02:54

marge_cpn
Messages: 16
Registered: July 2006
Location: Makati City, Philippines

Junior Member

Hi!

I am currently converting my PL/SQL scripts with UTL_FILE in forms and I have encountered a 'FILE_TYPE Invalid Identifier ' message when I compiled it.

When I was executing the same scripts, no problem was encountered.

May I ask,
a. Is there a difference between running the UTL_FILE in SQL prompt and running the UTL_FILE in forms?
b. What would I do to execute the UTL_FILE in oracle forms.

The UTL directory existed in our server and I really can't figure out why the same scripts can't run in oracle forms.

Thanks. Hope you can help me with this.

Marge

Report message to a moderator

Re: using UTL_FILE with oracle forms [message #206612 is a reply to message #206461]

Thu, 30 November 2006 17:41

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

Senior Member
Account Moderator

Are you using the same userid for both SQL*Plus and Forms?

David

Report message to a moderator

Re: using UTL_FILE with oracle forms [message #208545 is a reply to message #206461]

Mon, 11 December 2006 05:07

saravanan_faq
Messages: 8
Registered: November 2006
Location: bangalore

Junior Member

hi

Use TEXT_IO in forms 6i
CLIENT_TEXT_IO in forms 10g (WEBUTIL.PLL)

Rgs
Saravanan R
Bangalore

Report message to a moderator

Previous Topic:	Triggers firing at a time
Next Topic:	sending fax

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:45:18 CDT 2024