How to call the Oracle stored procedure in the C/C ++ encapsulation library ocicpplib

I have been using Mysql and Oracle databases for so many years. This time I have to use the C/C ++ language to call the Oracle stored procedure, so I am too lazy to look at the OCI API, I went online to find someone else's encapsulated library, and finally found this ocicpplib. I downloaded it and looked at it. It's good and easy to use. The following example shows how to use this database to call a stored procedure. If you call other SQL statements, you will not be able to use it. It is very easy to read the demo by yourself.

Ocicpplib database is: http://ocicpplib.sourceforge.net/

The following uses this simple stored procedure for testing. There are two output parameters: string and integer.

1. CREATE OR REPLACE PROCEDUREP_TEST
2. (
3. IDIN Int,
4. Name OUTVarchar2,
5. ResultOUT Int
6. )
7. IS
8. TmpVar NUMBER;
9. /*************************************** ***************************************
11. **************************************** **************************************/
12. BEGIN
13. TmpVar: = 0;
14. Name: ='Www .csdn.net';
15. Result: = 123456;
17. EXCEPTION
18. WHENNO_DATA_FOUNDTHEN
19. NULL;
20. WHENOTHERSTHEN
21. -- Consider logging the error and then re-raise
22. RAISE;
23. ENDP_TEST;

1 2 Next Page