1 пользователь считает эту информацию полезной
If you search the forum or just google this, then the first hit is this:
I understood, but I wanted a proper example with the IN and OUT parameters for the stored procedure. I am just curious to know how that works.
I have the following SP,
create or replace
COUNTRY_NAME,COUNTRY_SUBREGION INTO CN,CR
FROM COUNTRIES WHERE country_name = 'India';
Im using the SP in Physical layer and Execute COUNTRIES_PROC2() and defined 2 columns COUNTRY_NAME,COUNTRY_SUBREGION which my stored procedure will return. I've exposed this table in subject area.
But in my report it throwing error. Can Somebody Pls tell what Im doing wrong here?