PL/SQL w/ PS?

[kaznicki]

Does anyone know of a way to start a PL/SQL script or stored procedure through Peoplesoft?

 

[tzamora]

Hope this helps...
on a command button
SqlExec("myproc&quot

http://programmer-by-the-hour.com

 

[tzamora]

I just tried it...
Field(execute_pb) attatched to a "command button" in the FieldChange-event, I added the following...

SQLExec("EXECUTE 8x_ztree1 'SHARE' ,'BD_DEPARTMENTS','ALGO')"

http://programmer-by-the-hour.com

 

[vamsi10]

Hi,

We are currently on PeopleSoft Application release 8.0 and Tools
release 8.20.07..The Crystal reports version that we are using is Seagate
Crystal Reports Product 8.0.1.0..

I created a stored procedure in SQL Server and tried to link it to the
Crystal report..The problem is I don't see that stored procedure in the
Data Explorer Dialog box...Could anyone please advise why this is
happening..

Thanks in advance,
Vamsi