Stored Procedure is cannot found when create the database procedure proxy.

[former_member329238]

Hi Experts,

I have created a procedure proxy via XS artifact (.hdbprocedure), when i try to create the proxy for this procedure. Unfortunately, i am not able to find the created procedure in the wizard. Is there anyone can help on this?

Below are the screenshots for the details:

[Former Member]

Hi,

There is a great document available on SCN on how to do this, .

You can check your steps there.

Jonathan B.

[Former Member]

Hank,

I think your mistake is that you didn't share the procedure, can you check if you can find the procedure on the repository ?

And that you created it from the 'ABAP perspective' instead of the 'Modler' perspective (I think the 'HANA Development' perspective would have also been good.).

Jonathan B.

[pfefferf]

As already answered database procedure proxies support only the depreated ".procedure" procedures and not the newer ".hdbprocedure" procedures.

Regards,

Florian

[former_member329238]

Hi Florian,

As suggested, i created the deprecated procedure. Now i am able to see the procedure from content assistant. However, when i try to finish the processing, it shown me the error message "HANA Procedure is not available in DB Catalog (names are case sensitive!)". Actually, the procedure name was filled automatically. Any suggestion on this?

Best Regards,

Hank.

[pfefferf]

Did you check if the procedure exists in the DB catalog (check it in the catalog view). What I would also avoid are the Upper/Lower-case names of the packages (instead of "HDBModel.Procedures" I would write "hdbmodel.procedures"). Don't know if that can/will cause any issues, but it is the recommended way.

Regards,

Florian

[former_member329238]

Hi Florian,

Sorry for the late response and disturb again. 

I tried with your suggestion changed the package into low case. And it still show me the same error message.

Content assistant:

The procedure in DB catalog:

The error message:

Is there anything wrong with this?

Best Regards,

Hank.

Stored Procedure is cannot found when create the database procedure proxy.

[ravilla]

Hi Florian,

i have also same issue, created stored procedure in HANA Development in Repository, this will visible in catalog of my schema. but when i am trying to expose into ABAP, shows "HANA Procedure is not available in DB Catalog (names are case sensitive!)".

kinldly help me.

Thanks

Ravilla

[Former Member]

Hi florian.pfeffer,

I have the same issue. I can see my procedure is under _SYS_BIC schema. But when I've tried creating the db procedure proxy, it cannot find HANA procedure what I've created.

Regards,

Tri