Calling a stored procedure / package from Crystal Reports.NET

  • Thread starter Thread starter James Kent
  • Start date Start date
J

James Kent

Hello,

Does anyone have any experience or knowledge regarding calling a
stored procedure / package from Crystal Reports.NET? This damn
product is killing me!

Regards,
James Kent
 
Hi Jim,

What do you mean by '/package'? Calling a stored procedure is simple -
simply identify it when establishing the data source. Am I misinterpreting
what you want to do?

Bernie Yaeger
 
James said:
Hello,

Does anyone have any experience or knowledge regarding calling a
stored procedure / package from Crystal Reports.NET? This damn
product is killing me!

Regards,
James Kent
Click to expand...

You must use IN OUT REF CURSORS ... clearly stated in the help
information at Crystal.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
(e-mail address removed)
(replace 'x' with a 'u' to reply)
 
Bernie said:
Hi Jim,

What do you mean by '/package'? Calling a stored procedure is simple -
simply identify it when establishing the data source. Am I misinterpreting
what you want to do?

Bernie Yaeger
Click to expand...

Calling a procedure in a package requires a different syntax from
calling a procedure. The OP was just making sure there wasn't a
problem from Crystal. A perfectly reasonable concern.

If you don't know what a package is then you'd best find your way
to http://tahiti.oracle.com and
http://www.psoug.org/reference/packages.html and learn about them.

There is almost no excuse for writing a stored procedure in Oracle.
If your code isn't in a package you should have to justify why.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
(e-mail address removed)
(replace 'x' with a 'u' to reply)
 
Back
Top