> -----Message d'origine-----
> De : [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] la part de Anhaus,
> Thomas
> Envoy� : mardi 17 juin 2003 12:54
> � : [EMAIL PROTECTED]
> Cc : 'MM'
> Objet : RE:Problem with stored procedure returning a resultset
>
>
> momeunier wrote :
>
> >I have a very simple stored procedure which doesn't work and i don't
> >understand why
> >(in fact it is my first stored procedure :)
>
> >CREATE DBPROC DBA.GETLANGUE
> >AS
> > BEGIN
> > SELECT
> > LANG_LIBELLE, LANG_CODE
> > FROM
> > DBA.T_LANGUE ;
> > END
> >;
>
> >The creation works fine but it says "no result" when i call it
> >When i simply cut and paste the select in sql studio, i get my results...
> >So what's the problem ???
>
> If you want a db-procedure to return a cursor, you must specify
> this fact in the create dbproc statement :
>
> CREATE DBPROC DBA.GETLANGUE RETURNS CURSOR
> AS
> BEGIN
> $CURSOR = 'MYCURSOR';
> DECLARE :$CURSOR CURSOR FOR SELECT
> LANG_LIBELLE, LANG_CODE
> FROM
> DBA.T_LANGUE ;
> END
>
That's exacly what i tried to do after browsing the mailing list (ok i
should have done it before) but it still doesn't work...
I get error number 5110 : Missing value specification
Here is my create table :
CREATE TABLE "DBA"."T_LANGUE"
(
"LANG_ID" Smallint NOT NULL,
"LANG_LIBELLE" Varchar (16) ASCII NOT NULL,
"LANG_CODE" Varchar (16) ASCII NOT NULL,
PRIMARY KEY ("LANG_ID")
)
and i inserted my values using access
The problem occurs in java when using conn.prepareCall("CALL GETLANGUE")
Any hint ?
Thanx again
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
