Skip to Content
avatar image
Former Member

How to write a simple stored procedure in advantage data architect

hi


i am creating a WPF application using Advantage database server. I want to insert some data using stored procedure

Any sample code ?

i tried

two input parameter TestID and TestName ( both NCHAR)

Hide Copy Code

INSERT INTO TestTable(
                    Test_Id,
                    Test_Name)  
         VALUES (
	                 @TestID,
	                @TestName);




but show error like
Hide Copy Code

Error 7200:  AQE Error:  State = HY000;   NativeError = 5154;  [SAP][Advantage SQL Engine][ASA] Error 5154:  Execution of the stored procedure failed.   Procedure Name: TestInsert. Error 7200:  AQE Error:  State = S0000;   NativeError = 2121;  [SAP][Advantage SQL Engine]Column not found: @TestID -- Location of error in the SQL statement is: 42 (line: 3 column: 5) Error in stored procedure: TestInsert  AdsCommand query execution failed.


am new in SAP ADS.Please help me

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 17, 2017 at 09:41 AM

    use _XXXX notation for input parameters.

    Add comment
    10|10000 characters needed characters exceeded