用delphi6开发,使用ado连接,用oledb for oracle
调用存储过程的时候出现上面的问题
调用存储过程的时候出现上面的问题
解决方案 »
- 用什么技术可以实现数据库的实时更新
- select file_name from dba_data_files where tablespace_name='user01'为什么执行结果是未选定行?
- 请帮忙修改一条sql语句???
- delete语句的条件是not in +数组,如何写,谢谢!
- 我是菜鸟:请问我安装了开发工具oracle from ,oracle report,但是在连接服务器时总是提示12154--服务器名无法识别。
- oracle卸载问题!!!
- 请问用exp导出数据库时提示12520错误是怎么回事
- TO_DATE(T_SJ,'YYYY/MM/DD HH:MM:SS') 提示格式代码出现两次
- 大家帮帮我吧,我都急哭了两天了..有关sql server2000调用oracle8.1.7中存储过程的问题。
- 把两个PC文件连接在一起报sqlca重复定义,那位兄弟知道原因
- 在存储过程中,图片内容参数怎么传递!
- 请问在ORACLE储存过程中设置参数的默认值
Cause: Starting this instance would exceed the maximum number of instances allowed for this
database. This message occurs only with STARTUP shared and multiple instances.
Action: You cannot start more than the lower of:
the operating system-specific maximum or
the number of instances specified by the MAXINSTANCES option specified in the CREATE
DATABASE statement
但是有没有人知道哪里有补丁呢??Hi, I have a problem with 9i... does not exist in 8i. I wonder if it is a bug, or if I am interpreting these results somehow incorrectly.Summary: data dictionary tables seem inconsistent, which causes the Oracle OLEDB/ADO driver to fail when doing a Command.Parameters.Refresh() when the Command object is pointed to a stored procedure.I will explain from the ground-up (reverse order as discovered in troubleshooting).Suppose I have a procedure defined in my schema named 'PROC'. There is no
package, just a procedure.ON 8.1.6:
SQL> select o.name, a.procedure$ from
2 argument$ a, obj$ o
3 where o.obj# = a.obj# and
4 o.name = 'PROC' ;NAME PROCEDURE$
------------------------------ ------------------------------ PROC<<notice the blank in PROCEDURE$ >>ON 9.0.1:
SQL> select o.name, a.procedure$ from
2 argument$ a, obj$ o
3 where o.obj# = a.obj# and
4 o.name = 'PROC' ;NAME PROCEDURE$
------------------------------ ------------------------------
PROC PROC<<exact same query, exact same schema, different results>>Now, this would be purely academic, except for the ALL_ARGUMENTS view, which is defined the same in 8i and 9i. The relevant code in this view is...
VIEW ALL_ARGUMENTS:
select
<<snip>>
nvl(a.procedure$,o.name), /* OBJECT_NAME */ decode(a.procedure$,null,null, o.name), /* PACKAGE_NAME */ <<snip>> from obj$ o,argument$ a,user$ u where o.obj# = a.obj# <<snip>>Now, reading between the lines here one can infer that in the ALL_ARGUMENTS view, my procedure PROC appears to be:
8i: PACKAGE_NAME: null, OBJECT_NAME: PROC
9i: PACKAGE_NAME: PROC, OBJECT_NAME: PROCwhere the 9i view is clearly erroneous. It is causing the ADO driver to
break since that uses ALL_ARGUMENTS.Is this a known 9i bug, or a problem with my thinking :)Thanks,
JT.