Skip to Content
0

How to write a simple stored procedure in advantage data architect

Nov 17, 2017 at 09:05 AM

129

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Joachim Dürr Nov 17, 2017 at 09:41 AM
1

use _XXXX notation for input parameters.

Share
10 |10000 characters needed characters left characters exceeded