Christian Ariel wrote : >I have been trying to create a stored procedure but I have received an >error:
>Integrity constraint violation;-8006 POS(1) Data types must be >compatible. >Store procedure I want to create is: >Create DBProc sa.prueba (IN DSET varchar) >as >INSERT INTO sa.prueba (DS) >VALUES (:DSET); >Table definition is >TABLE "SA"."PRUEBA" >( > "ID" Integer DEFAULT SERIAL (1), > "DS" Long ASCII >) >What I making wrong? Sorry, but at the moment it is not possible to operate on columns of datatype long inside db-procedures. This feature is on our TODO list. If possible change column "DS" and the parameter DSET to varchar(8000). 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
