可能导致ORA-01009错误的原因 SQL或PL/SQL代码中的参数缺失:在编写SQL或PL/SQL代码时,可能忘记了为某个需要参数的函数或过程提供必要的参数。 数据库作业(Job)参数配置错误:如果Oracle数据库中配置了自动执行的作业(Job),并且这些作业在执行时需要特定的参数,但参数没有正确设置或传递,就会导致ORA-01009错误。 网络...
ORA-01009:必须得参数缺少(missing mandatory parameter) 症状:同样的sql 语句,在plsql developer中可以执行,但在程序中却报出这个异常 解决方法:更换ojdbc14.jar驱动 查看ojdbc驱动对应的oracle版本方法:打开ojdbc 的jar包,查看MANIFEST.MF文件,查看Specification-Version和Implementation-Version两个字段值。例如下面jdbc14...
I am porting from Interbase to Oracle using the direct path loader. Some, though not all, tables with blobs fail with ORA-01009. I have tried all sorts of combinations of buffer size and extra .DataSize to no avail. In my sample code below I double up for good measure. My Code Except...
Database is generating excessive cdmp traces. Checked the alert log and found these two ORA ERRORS... ORA-03137: TTC protocol internal error : [1009] [] [] [] [] [] [] [] ORA-01009: missing mandatory parameter its generating cdmp every mintue and so...Please suggest a real time ...
If you are using the Oracle thin driver and the OCI driver, surrounding a query with parentheses ("()") results in the error "ORA-01009: missing mandatory parameter" and an empty result set (no data). This is an Oracle error (917674) and was fixed in the 817.2 fixset. To avoid the...
ORA-01009-missing mandatory parameter The sql is very big. How to solve this problem. Pls. help. It's urgent Regards Reeti DAYANAND BURAMSHETTY Ranch Hand Posts: 34 posted 23 years ago Hi, write dubug statement for display the sql query statement and check.Sometimes we forget to write...
Using jdk1.3 and classes12_01, if I create either a Statement or a PreparedStatement from a string read in from a file, I get ORA-01009 if the file had windows line endings. If I save the file back out with Unix line endings, there's no problem. This is not a fix, however, sinc...