[PHP-DB] ORACLE dbms_sql - problems with select

Please , I can´t show the results of this procedure... STR_SELECT := STR_SELECT || ' AND EMP.EMP_CODIGO ' || INICIO || ' AND ROWNUM (SELECT PAR_VALOR FROM PAR WHERE PAR_DESCRICAO = ' || VALOR || ')'; CURSOR1 :=DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(CURSOR1,STR_SELECT,2); ROW_PROC

[PHP-DB] HELP!!! Troubles with Oracle

Please, I´m having a big problem to bring cursor from Oracle. I have no troubles using statics queries, but when i use dynamic queries (dbms_sql) with array occurs the follow error mensage: Warning: failed to rollback outstanding transactions!: ORA-01041: internal error. hostdef

[PHP-DB] ORACLE JOB

I need to do a select or a insert based in a variable Something like this $select = SELECT * FROM TABLE1 and after i do the select above with is in the variable... All help is important... Thanks Fernando -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] how should i test my php program performance?

Hi, You can get the time(); or microtime(); (in linux) in the beginning and in the endo of the code.. example: ? $t1 = time(); code... $t2 = time(); echo Total time is.($t2 - $t1).seconds.; ? []s Ferreras Dear all: I have wrote a php program and use mysql database. Is there a way to

[PHP-DB] Oracle Jobs

Hi everyone, Does anyone knows how i can create a job in oracle to go to a specify url or send a email Thanks a lot. Fernando Ferreras -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED