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

[Dattatraya Shetty <datta_shetty@yahoo.com>]

Hi Kevin,
   The Select Statement you have works as is on our System. 
UNIX / SQR 4.3. ORACLE 8.1. I am not sure if the Select is Error see if
the Error is some other place. 

HTH 
Datta. 
--- James Womeldorf <jwomeldo@fastenal.com> wrote:
> 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



        
                
__________________________________
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25˘
http://photos.yahoo.com/ph/print_splash

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