aix unix 调用oracel 存储过程例子

Question

请提供 一个aix unix 调用oracel  存储过程例子谢谢

Answer 1

楼主是指在shell里面吗？搞一个shell脚本文件，内容类似如下：sqlplus user/pass@dbname <<EOF
exec procedurename;
quit;
EOF或者sqlplus user/pass@dbname @script.sqlscript.sql中包含内容：exec procedurename;

Answer 2

pro*c里调用SP        EXEC SQL EXECUTE
                BEGIN
                           sp_test(...);
                END;
        END-EXEC;
        if (sqlca.sqlcode != 0)
        {
         return -1;
        }
        return 0;