Re: Stored Procedures and Built Ins - Please Help !!

Regrettably you can't
Forms and the server are using two different versions of PL/SQL. The TEXT_IO procedure is in the Forms PL/SQL only.
You'll either need to use dbms_output or utl_file in stored procedures.

Regards,

Sybrand Bakker, Oracle DBA

Chris <Chris_Prince_at_bccomp.demon.co.uk> wrote in message news:iU7m9FASvf24UAs7_at_bccomp.demon.co.uk...
>
> HELP !!
>
> Hi,
>
> I wonder if anyone can help me with this, or at least point me in the
> right direction ?. I'm trying to write a stored procedure that utilises
> the built-in package TEXT_IO, I can get it to work in Forms and
> Procedure Builder, but not as a stored procedure. I'm guessing that I
> have to link the Procedure and the Built-In in some way, but I don't
> have a clue how to do it :(, can somebody please help ?, I'm sure it's
> simple when you know how, I just don't :(
>
> TIA
>
> Chris
>
Received on Thu Mar 23 2000 - 06:03:42 CST