Waldemar Urbanek wrote :
>Hi,
>I have a Problem with my newly installed SAP DB 7.4 trying to evaluate some
>Functions preparing SAP DB for productive usage (or maybe not ??)
>Env: SAP DB 7.4 under MsWindows 2000 Prof. (Server) and SAP DB SQL Studio
>7.4 for MsWindows 2000 Prof.
>The error pops up every time I try to define the scond DBPROC !
>CREATE TABLE "URBA"."DEBUGLOG"
>(
> Meld Varchar (1000) ASCII,
> Datum Date DEFAULT DATE,
> Zeit Timestamp DEFAULT TIMESTAMP
>)
>CREATE DBPROC FEHLERLOG (IN INFO VARCHAR(1000) ) AS
> TRY
> INSERT INTO URBA.DEBUGLOG(MELD) values (:INFO);
> CATCH
> STOP(1,'Stop');
>CREATE DBPROC TESTPROC (IN INFO VARCHAR(1000) ) AS
> TRY
> call URBA.fehlerlog('... gestartet: TESTPROC ...');
> call URBA.fehlerlog('... weitergereicht aus TESTPROC: ' & INFO);
> CATCH
> STOP(1,'Stop');
>
>..... Native Error 800 /DB Server crash !!!)
>
>The DBPROC works fine when a Literal is passed but whenever I try to pass
>the Parameter INFO
>CREATE DBPROC TESTPROC (IN INFO VARCHAR(1000) ) AS
> TRY
> call URBA.fehlerlog('... gestartet: TESTPROC ...');
> call URBA.fehlerlog(INFO);
> CATCH
> STOP(1,'Stop');
>
>.... Native Error -8004 Constant must be compatible with column type and
>length
> Best regards and thanks for helping me
The call of a db-procedure from a db-procedure is a call of a sql
statement, i.e. parameters in this call have to be indicated by a colon.
Please correct the statement 'call URBA.fehlerlog(INFO);' to
'call URBA.fehlerlog(:INFO);'.
The kernel crash caused by this error is a known bug which has already
been fixed in our current development release (which is not available for
you yet).
Best Regards,
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
