Stored procedure from JDBC in VC

[benot_delporte]

Hello

We're starting to use VC 7.0 SP14.

We've already made few applications using JDBC tables or view and BAPI.

Now we want to use stored procedures of the same DB.

Our DB system was created as a "SAP_BI_JDBC". But when I look in VC, I can see my system but it only proposes me to "look for a table" or to "browse table catalog". Here I don't see my stored procedures.

Hence, I tried to create a "JDBC Systems" but now I can connect to it (connection test fail).

Can any one help by giving me the parameters to use on the DB side, or portal's system parameters, ...

Thank you !

Benoit

[Former Member]

Have you managed to connect to your procedures? You are right to use JDBC and not BI_JDBC system. What database are you connecting to. I am currently connecting to my Oracle DB procedures for many models - without problems.

Henning Strand

[Former Member]

Hi,

You test the Connection in the prortal if it fails then it is problem woth Usermapping.

Do the usermapping for that DB

then try again

Govindu