Skip to Content
avatar image
Former Member

Stored procedure from JDBC in VC

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 02, 2008 at 04:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 01, 2008 at 08:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded