Home » Developer & Programmer » Forms » using UTL_FILE with oracle forms
icon4.gif  using UTL_FILE with oracle forms [message #206461] Thu, 30 November 2006 02:54 Go to next message
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
Re: using UTL_FILE with oracle forms [message #206612 is a reply to message #206461] Thu, 30 November 2006 17:41 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Are you using the same userid for both SQL*Plus and Forms?

David
Re: using UTL_FILE with oracle forms [message #208545 is a reply to message #206461] Mon, 11 December 2006 05:07 Go to previous message
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
Previous Topic: Triggers firing at a time
Next Topic: sending fax
Goto Forum:
  


Current Time: Sat Dec 10 16:49:34 CST 2016

Total time taken to generate the page: 0.08132 seconds