RE: [sqr-users] get oracle database name from SQR

["Hale, Keith" <keith.hale@impactinnovations.com>]

How about select * from global_name?  You can then parse the db name.

Keith

-----Original Message-----
From: James Womeldorf [mailto:jwomeldo@fastenal.com] 
Sent: Thursday, April 22, 2004 9:35 AM
To: 'This list is for discussion about the SQR database reporting language
from Hyperion Solutions.'
Subject: RE: [sqr-users] get oracle database name from SQR

Hi Kevin,

We use this procedure:

begin-procedure get_database_name(:$database_name)
begin-select 
value   &database_name
        let $database_name = &database_name
from v$parameter
where name = 'db_name'
end-select 
end-procedure get_database_name

Jim Womeldorf


-----Original Message-----
From: Kevin Laroche [mailto:bydesign@magma.ca]
Sent: Thursday, April 22, 2004 8:13 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] get oracle database name from SQR


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

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

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