PL/SQL: Return types of Result Set variables or query do not match

i've found my solution ...

i wanted to put in a complete rowtype only one field ... i changed this in concerned stocked procedure and it works :

CREATE OR REPLACE PACKAGE BODY pkg AS  

 PROCEDURE loop_prxetu ( cur_prxetu IN OUT ref_cur, rec IN OUT prxetu%ROWTYPE ) IS
 BEGIN   OPEN cur_prxetu FOR SELECT * FROM prxetu;

....instead of ....

CREATE OR REPLACE PACKAGE BODY pkg AS  

 PROCEDURE loop_prxetu ( cur_prxetu IN OUT ref_cur, rec IN OUT prxetu%ROWTYPE ) IS
 BEGIN   OPEN cur_prxetu FOR SELECT idntecprxetu FROM prxetu;

thanks to people who try to help me :) Received on Wed Mar 31 2004 - 04:14:06 CST