Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL: Return types of Result Set variables or query do not match

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

From: funka <pjpameole_at_sopragroup.com>
Date: 31 Mar 2004 02:14:06 -0800
Message-ID: <da8084ca.0403310214.195b4359@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US