Publishing process:
1, write .java file
2, successfully compile .java file, generate .class files, this file is file imported into Oracle.
3, (Toad Tool Method Import), open the Java Manager refer to the .class file, execute the import.
Note that if you have sufficient permissions at this point, you can import the file into the specified Schema.
After the introduction is complete, you can find the Java class in the Java directory in the imported Schema, which identifies to J (c), the Java Class file.
4, publish file, specify the functions to be released, and the internal calling of Functions does not need to be released.
Once the release is completed, all PROCS directories can be found in the Procs directory in the imported Schema, Functions, and Procedures.
Calling process: SQLPLUS as an example
1. Log in to the database at the time of import
2, SQL> Variable Msg Varchar2 (2000);
/ / Define the variable MSG, specify the length.
3, SQL> Call sendsms.makesettingdata ('16000', '9200', '', 'Y', 'N', '9999', '210.51.1.4', '11111', '210.51.1.4', '22222 ',' AnzHezhu @ Win001.ad.leadtone.com ') INTO: MSG;
Call completion
// Use the call to call the function and output the result to the MSG.
Note: There is no Boolean data type in Oracle, which involves this type of variable should be replaced by a string manner.
SQL> Print MSG
MSG
-------------------------------------------------- ------------------------------
0605043E
8023F
001061C
196170706C
69636174696F6E
2F636D63632E73657474696E6700AF890200
0502000000002E270FD23301042B67D233010456CE616E
7A
68657A68754077696E303030312E61642E
6C
656164746F
6E652E
636F6D00
