Re: problems with stored procedure (ORACLE 8.1.5)

i am not sure but i think that select * from does not work try to put the name of the column instead of the *

"André Klos" wrote:

> Hi Group!
>
> I've got a problem with the following stored-procedure:
>
> procedure getOfferData (acustid in
> pik_cse_product_text.cust_id_at_DATENBASELINK%type,
> aprojid in
> pik_cse_product_text.proj_id_at_DATENBASELINK%type,
> ainstid in
> pik_cse_product_text.inst_id_at_DATENBASELINK%type,
> aproductid in
> pik_cse_product_text.product_id_at_DATENBASELINK%type,
> acountryid in
> pik_cse_product_text.country_id_at_DATENBASeLINK%type,
> acustomergroupid in
> pik_dci_text_types.customer_group_id%type,
> aarticlecursor in out
> article_cursor,
> aerrornr out number,
> aerrormsg out varchar2) is
>
> begin
>
> open aarticlecursor
> for select *
> from pik_cse_offer_list
> where cust_id = acustid
> and inst_id = ainstid
> and proj_id = aprojid
> and product_id = aproductid
> and country_id = acountryid
> and customer_group_id = acustomergroupid;
>
> exception
> when others then
> aerrornr := sqlcode;
> aerrormsg := substr(sqlerrm, 1, 200);
>
> end;
>
> pik_cse_offer_list --> view --> gets data from an other view
>
> When I execute the stored-procedure, I get the following error-message:
> ORA-01008: not all variables bound
> ORA-02063: preceding line from "Name des Datenbanklinks"
>
> All parameters and the views are correct.
>
> Thanks
>
> André
Received on Sun Jul 22 2001 - 08:53:45 CEST