Great, thanks. Best Regards. Rafael Visser
2009/1/20, Russell, Gordon <[email protected]>: > Hia. > Try taking "--ash.event_id" out. > Last time I tried this, DBI/DBD didnt support comments. > That is handled in the sqlplus interface only. > > Hope that helped. > Gordon. > > > -----Original Message----- > From: Rafael Visser [mailto:[email protected]] > Sent: 20 January 2009 13:07 > To: [email protected] > Subject: ORA-00923 > > Hi. > > The following sql runs ok by sqlplus on the server. > > =================================================================================== > SQL> !more wait_class_ii.sql > with aux as ( select *--ash.event_id > FROM gv$active_session_history ash > where ash.sample_time > SYSDATE - 1/1440) > select evt.wait_class, count(ash.event_id) > FROM aux ash, gv$event_name evt > where > evt.wait_class in ('User I/O','Network','System > I/O','Commit','Other','Application', > 'Configuration','Concurrency','Cluster','Administrative') > AND ash.event_id(+) = evt.event_id > GROUP BY evt.wait_class; > > SQL> @wait_class_ii.sql > > WAIT_CLASS > COUNT(ASH.EVENT_ID) > ---------------------------------------------------------------- > ------------------- > User I/O > 495 > Application > 0 > Network > 108 > Concurrency > 1 > Administrative > 0 > Configuration > 0 > Cluster > 0 > Other > 169 > System I/O > 23 > Commit > 16 > > 10 filas seleccionadas. > > SQL> > =================================================================================== > > > > But, when run the same sql on dbi on a client machine, i receive the > following error: > DBD::Oracle::db prepare failed: ORA-00923: palabra clave FROM no > encontrada donde se esperaba (DBD ERROR: error possibly near <*> in > dicator at char 134 in 'with aux as (SELECT *--ash.event_id FROM > gv$active_session_history ash where ash.sample_time > SYSDATE - 1/ > 1440) > > > This is a part of The code > > > $sth=$dbh->prepare("with aux as (SELECT *--ash.event_id FROM > gv\$active_session_history ash where ash.sample_time > SYSDATE - > 1/1440) > SELECT evt.wait_class, count(ash.event_id) FROM aux ash, > gv\$event_name evt > where evt.wait_class in ('User I/O','Network','System > I/O','Commit','Other','Application', > 'Configuration','Concurrency','Cluster','Administrative') > AND ash.event_id(+) = evt.event_id > GROUP BY evt.wait_class > ORDER BY count(ash.event_id) DESC "); > > > > Do you know where am i doing wrong?.. > > SUSE Linux version 2.6.16.60-0.31-xen > Perl Version = 5.008008 > DBI Version = 1.605 > > > Thanks in Advance. > rv > > > Napier University is the best modern university in Scotland* and number one > in Scotland for graduate employability** > (*Guardian University Guide 2009) > (**HESA 2008) > > This message is intended for the addressee(s) only and should not be read, > copied or disclosed to anyone else outwith the University without the > permission of the sender. > It is your responsibility to ensure that this message and any attachments > are scanned for viruses or other defects. Napier University does not accept > liability for any loss or damage which may result from this email or any > attachment, or for errors or omissions arising after it was sent. Email is > not a secure medium. Email entering the University's system is subject to > routine monitoring and filtering by the University. > Napier University is a registered Scottish charity. Registration number > SC018373 > > >
