 | |
DBMS_OUTPUT and PHP
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DBMS_OUTPUT and PHP -
06-01-2008
, 11:52 AM
#2
| |||
| |||
|
|
Hello, (I've post this message on php newsgroup too, without success...) When executing PL-SQL code from php, is there a way to obtain the result of the DBMS_OUTPUT directly into php? Because i've failed. Instead, I use the UTL_FILE package to write a file and copy it by ftp on the web server, that seems to me a little heavy... Thanks ! |
won't get any responses?
On 9i and higher you could create a PIPELINED PL/SQL function and PIPE
ROW the characters you would have sent to dbms_output.
Pipelined functions return a resultset/table.
On 8i and higher you could store the output in a pl/sql collection
(table of varchar2(...) indexed by pls_integer;
and output the pl/sql table to a REF CURSOR, using select * from
cast(table(<your collection variable>)
Http://asktom.oracle.com will have examples.
--
Sybrand Bakker
Senior Oracle DBA
#3
| |||
| |||
|
|
Hello, (I've post this message on php newsgroup too, without success...) When executing PL-SQL code from php, is there a way to obtain the result of the DBMS_OUTPUT directly into php? Because i've failed. Instead, I use the UTL_FILE package to write a file and copy it by ftp on the web server, that seems to me a little heavy... Thanks ! |
won't get any responses?
On 9i and higher you could create a PIPELINED PL/SQL function and PIPE
ROW the characters you would have sent to dbms_output.
Pipelined functions return a resultset/table.
On 8i and higher you could store the output in a pl/sql collection
(table of varchar2(...) indexed by pls_integer;
and output the pl/sql table to a REF CURSOR, using select * from
cast(table(<your collection variable>)
Http://asktom.oracle.com will have examples.
--
Sybrand Bakker
Senior Oracle DBA
#4
| |||
| |||
|
|
Hello, (I've post this message on php newsgroup too, without success...) When executing PL-SQL code from php, is there a way to obtain the result of the DBMS_OUTPUT directly into php? Because i've failed. Instead, I use the UTL_FILE package to write a file and copy it by ftp on the web server, that seems to me a little heavy... Thanks ! |
won't get any responses?
On 9i and higher you could create a PIPELINED PL/SQL function and PIPE
ROW the characters you would have sent to dbms_output.
Pipelined functions return a resultset/table.
On 8i and higher you could store the output in a pl/sql collection
(table of varchar2(...) indexed by pls_integer;
and output the pl/sql table to a REF CURSOR, using select * from
cast(table(<your collection variable>)
Http://asktom.oracle.com will have examples.
--
Sybrand Bakker
Senior Oracle DBA
#5
| |||
| |||
|
|
Hello, (I've post this message on php newsgroup too, without success...) When executing PL-SQL code from php, is there a way to obtain the result of the DBMS_OUTPUT directly into php? Because i've failed. Instead, I use the UTL_FILE package to write a file and copy it by ftp on the web server, that seems to me a little heavy... Thanks ! |
won't get any responses?
On 9i and higher you could create a PIPELINED PL/SQL function and PIPE
ROW the characters you would have sent to dbms_output.
Pipelined functions return a resultset/table.
On 8i and higher you could store the output in a pl/sql collection
(table of varchar2(...) indexed by pls_integer;
and output the pl/sql table to a REF CURSOR, using select * from
cast(table(<your collection variable>)
Http://asktom.oracle.com will have examples.
--
Sybrand Bakker
Senior Oracle DBA
#6
| |||
| |||
|
|
Hello, (I've post this message on php newsgroup too, without success...) When executing PL-SQL code from php, is there a way to obtain the result of the DBMS_OUTPUT directly into php? Because i've failed. Instead, I use the UTL_FILE package to write a file and copy it by ftp on the web server, that seems to me a little heavy... Thanks ! I think you aske the wrong question: DBMS_OUTPUT will only echo the |
come in, use DBMS_PIPE
--
Regards,
Frank van Bortel
#7
| |||
| |||
|
|
Hello, (I've post this message on php newsgroup too, without success...) When executing PL-SQL code from php, is there a way to obtain the result of the DBMS_OUTPUT directly into php? Because i've failed. Instead, I use the UTL_FILE package to write a file and copy it by ftp on the web server, that seems to me a little heavy... Thanks ! I think you aske the wrong question: DBMS_OUTPUT will only echo the |
come in, use DBMS_PIPE
--
Regards,
Frank van Bortel
#8
| |||
| |||
|
|
Hello, (I've post this message on php newsgroup too, without success...) When executing PL-SQL code from php, is there a way to obtain the result of the DBMS_OUTPUT directly into php? Because i've failed. Instead, I use the UTL_FILE package to write a file and copy it by ftp on the web server, that seems to me a little heavy... Thanks ! I think you aske the wrong question: DBMS_OUTPUT will only echo the |
come in, use DBMS_PIPE
--
Regards,
Frank van Bortel
#9
| |||
| |||
|
|
Hello, (I've post this message on php newsgroup too, without success...) When executing PL-SQL code from php, is there a way to obtain the result of the DBMS_OUTPUT directly into php? Because i've failed. Instead, I use the UTL_FILE package to write a file and copy it by ftp on the web server, that seems to me a little heavy... Thanks ! I think you aske the wrong question: DBMS_OUTPUT will only echo the |
come in, use DBMS_PIPE
--
Regards,
Frank van Bortel
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.