返回“DESC 包”；在 PHP 中使用 OCI

发布于 2024-08-10 11:31:24 字数 350 浏览 6 评论 0原文

您好，我正在尝试使用 OCI8 直接从 PHP 获取有关 Oracle 包的信息：

$sql = 'DESC my_package';
$stmt = oci_parse($conn, $sql);
oci_execute($stmt);

这会返回：

Warning: oci_execute() [function.oci-execute]: ORA-00900: invalid SQL statement in /oci8_test.php on line 16

我知道该命令可以正常工作，就像我在 SQLPlus 中尝试的那样。

有谁知道如何实现这一目标。

谢谢

原文

Hi I am trying to get information on an Oracle package directly from PHP using OCI8:

$sql = 'DESC my_package';
$stmt = oci_parse($conn, $sql);
oci_execute($stmt);

this returns:

Warning: oci_execute() [function.oci-execute]: ORA-00900: invalid SQL statement in /oci8_test.php on line 16

I know the command works as I tried it in SQLPlus.

Does anyone know how to achieve this.

Thx

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

碍人泪离人颜 2024-08-17 11:31:24

DESC 是 SQL Plus 命令。

我已经离开 Oracle 几年了，但还是查看了一下数据字典。例如，对于表格，您可以执行以下操作。也必须有一些用于包的东西。
DESC MY_TABLE

相当于

SELECT 
column_name "Name", 
nullable "Null?",
concat(concat(concat(data_type,'('),data_length),')') "Type"
FROM user_tab_columns
WHERE table_name='TABLE_NAME_TO_DESCRIBE';

DESC is a SQL Plus command.

I have been away from Oracle for a few years now, but look into the data dictionary. For example for tables you could do below. There must be something for Packages as well.
DESC MY_TABLE

is equivalent to

SELECT 
column_name "Name", 
nullable "Null?",
concat(concat(concat(data_type,'('),data_length),')') "Type"
FROM user_tab_columns
WHERE table_name='TABLE_NAME_TO_DESCRIBE';

回复收藏 0 原文

流年已逝 2024-08-17 11:31:24

谢谢您的回复，我想我已经找到了答案。

因此，对于任何感兴趣的人，正如文森特所说，我认为要使其发挥作用，您必须创建自己的“DESC”。
要使用的 Oracle 视图是“user_arguments”，您可以获取函数/过程名称、参数名称和类型、参数位置等...

Select * from user_arguments where package_name = 'my_package'

Thx for the replies, I think I have found my answer.

So for anyone who is interested, as Vincent said, I think to make it work you'll have to create your own 'DESC'.
The Oracle View to use is 'user_arguments', you get the function/procedure names, argument names and types, argument position, etc...

Select * from user_arguments where package_name = 'my_package'

回复收藏 0 原文

淑女气质 2024-08-17 11:31:24

DESC 是一个 SQL*Plus 命令，它无法在 SQL*Plus 中运行。您可以通过从任何工具查询数据字典来编写自己的 DESC：

SQL> SELECT column_name, data_type, data_length,
  2         data_precision, data_scale, nullable
  3    FROM all_tab_columns
  4   WHERE table_name = 'T';


COLUMN_NAME  DATA_TYPE  DATA_LENGTH DATA_PRECISION DATA_SCALE NULLABLE
------------ ---------- ----------- -------------- ---------- --------
COLUMN1      CHAR                 6                           Y
COLUMN2      CHAR                 6                           Y

DESC is a SQL*Plus command, it won't work out of SQL*Plus. You can write your own DESC by querying the data dictionnary from any tool:

SQL> SELECT column_name, data_type, data_length,
  2         data_precision, data_scale, nullable
  3    FROM all_tab_columns
  4   WHERE table_name = 'T';


COLUMN_NAME  DATA_TYPE  DATA_LENGTH DATA_PRECISION DATA_SCALE NULLABLE
------------ ---------- ----------- -------------- ---------- --------
COLUMN1      CHAR                 6                           Y
COLUMN2      CHAR                 6                           Y

回复收藏 0 原文

~没有更多了~