Bind output of a strored procudure

[Former Member]

Hi All,

I am trying to call a stored procedure from sql editor using the below syntax.

call "sys_bic"."store_proc"("test")

store_proc takes a scalar input parameter and returns a table type as out put parameter.

Can anyone please let me know how to bind the output of store_proc to the results in sql editor

Thanks,

Goutham

[former_member182114]

Hi Goutham,

Use ? as second parameter:

call _sys_bic.procedure('test',?)

Regards, Fernando Da Rós

[former_member182302]

Adding to Fernando's reply:

Even null works.

As he mentioned, you can try:

1) call _sys_bic.procedure('test',?)

2) call _sys_bic.procedure('test',null)

Regards,

Krishna Tangudu