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
Dr.Waldemar Urbanek
Client Server
BVG - Gesellschaft f�r Unternehmensberatung mbH
Menkestra�e 7
D-26419 Schortens
Call: +49(0)44 61 / 985 - 128
Fax: +49(0)44 61 / 985 - 499
eMail: [EMAIL PROTECTED]
Internet http://www.bvg-fri.de/
Aktuelles zum Thema ISO9000ff:2000 Qualit�tsmanagement finden Sie auf
unserer Homepage!http://www.bvg-fri.de/beratung/index3.htm
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
