C Business Functions w/ SQL Stored Procedures

[jdetech03]

Hello All,

Does anyone have some sample code of how to call stored procedures from a "C" Business Function in JDE?

The scenario is as follows:
The Stored Procedure is already created in SQL.
The BSFN will call the SP w/ 10 of parameters and the SP will return 2 result parameters.

Thanks in advance for your help.

 

[jolly]

Hi,

This has been covered in this forum before so a quick search should find it.

Cheers,
JohnO

 

[jdetech03]

I searched the list and found no sample code. Can you provide something to assist me? Thanks.

 

[jolly]

See JBates posting and attachment here:

http://www.jdelist.com/ubb/showthre...&Searchpage=0&Limit=25&Old=3months&Main=68947

He was having problems getting this to work, but the code was pretty complete.

For a general article on accessing native ODBC see OneWorld Whipping Boy's article here:

http://www.ocode.net/odbcbsfn.htm

Good luck - and please post your results when you try this!
JohnO