[sqr-users] get oracle database name from SQR

["Kevin Laroche" <bydesign@magma.ca>]

Hi to all
I am developing a log of what sqr reports are run by which users and how long 
they take.
How can I determine the database name that the user logged onto?
I tried
select name from v$database,
select global_name from global_name,

 begin-select
 global_name   &vdbname
 from global_name
 end-select

these work great in oracle or SQL but give an error if run from SQR
"Error in include file "write_log.sqh" on line 33:
   (SQR 3704) Missing procedure name.
  from global_name"

I must be missing some really obvious thing. Any suggestions?

Oracle 8.06/SQR 6.0/Windows 2000 clients
Kevin LaRoche
Oracle Forms Developer
Canadian Human Rights Commission
Ottawa Ontario
K2E 5G2

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users