RE: [sqr-users] help needed...

["Harris, Sam" <SVH@CDRH.FDA.GOV>]

I have used stored procedures quite a number of times in SQR reports and got
the desired results. Here is an example. 
I have a store procedure called Get_applicant_name. It take four arguments.
The select clause looks something like this.

Begin-select
sysdate                          &sysdate
Get_applicant_name( arg1, arg2, arg3, arg4 ) &applicant_name

>From dual
End-select

I not use the sysdate, but when I remove it from the select I got an error.
It does not have to be sysdate. It can be any column from your database.
I think the call to your stored procedure cannot stand alone. It has to be a
part of an actual select clause. There is probably a better way, But this is
the way it has worked for me.

-----Original Message-----
From: Srini . [mailto:vasbrio@hotmail.com] 
Sent: Thursday, November 07, 2002 1:25 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] help needed...



Hi Friends,

I am a SQR Programmer, In my report, I need to use stored procedures, please

how can i use stored procedures in SQR. I appreciate early reply.

Thanks
Srini




_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

_______________________________________________
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