主页 / user-302360

Vadim Artyushenko's questions

Martin Hope
Vadim Artyushenko
Asked: 2022-01-28 14:14:33 +0000 UTC
  • 1

我不明白如何按照某些条件给出的特定顺序向光标写入行。那些。在任何情况下，查询结果中都必须包含感兴趣的行，但要求它恰好是游标中的最后一行。

无法选择所需的排序，将其放在最后位置的条件由位于该行的其中一个字段中的值确定（在下面的示例中，条件为s.service_synonym = 'AutoCloseOrder'）。

试过 via UNION，但它仍然没有将所需的行放在光标的末尾：

create or replace procedure get_service2(p_document_id number, res out sys_refcursor)
is
begin
  open res for
  select s.service_id, s.service_synonym from document d
  join service s on d.service_id = s.service_id
  where d.document_id = p_document_id and (s.service_synonym <> 'AutoCloseOrder' or s.service_synonym is null) 
  union
  select s.service_id, s.service_synonym from document d
  join service s on d.service_id = s.service_id
  where d.document_id = p_document_id and s.service_synonym = 'AutoCloseOrder';
  --order by s.service_synonym desc;   
end get_service2;
oracle
Martin Hope
Vadim Artyushenko
Asked: 2020-08-07 15:56:23 +0000 UTC
  • 2

请求与序言一起以CLOВXML 格式存储：

POST:...
Cache-Control: no-cache
Connection: keep-alive
...
SOAPAction: ...


<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
  <SOAP-ENV:Header>
  </SOAP-ENV:Header>
  <SOAP-ENV:Body>
   ... 
   *тело SOAP-запроса*
   ...
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

我正在尝试编写一个我处理的 PL/SQL 过程CLOB，但是xmlТype()有了这些数据，它给出了一个跟踪。错误：

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of 'P'
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1
xml
Martin Hope
Vadim Artyushenko
Asked: 2020-07-09 16:51:44 +0000 UTC
  • 2

为了创建用户，我通过 SQL*Plus 运行了以下命令：

SQL> conn / as sysdba;
Connected.

SQL> alter session set container = orclpdb;
Session altered.

SQL> create user admin identified by qq;
User created.

SQL> grant dba to admin;
Grant succeeded.

SQL> connect admin/qq@db12c;
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

我一直收到这个错误：

ORA-01017: 无效的用户名/密码；登录被拒绝

我究竟做错了什么？

我还将附上 tnsnames.ora 文件：

# tnsnames.ora Network Configuration File: C:\app\admin\product\12.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
PROBA.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = PROBA)
    )
  )

LISTENER_DB12C =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

DB12C =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db12c)
    )
  )
sql