PLS00201使用Python执行Oracle数据库PL/SQL过程时

2024-05-18 19:24:04 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在尝试运行以下代码

import cx_Oracle

p0_ = 'NULL'
p1_ = 'NULL'
p2_ = 'NULL'
p3_ = '''OPPORTUNITY_NO'||chr(31)||'2019-ttt'
||chr(30)||'DESCRIPTION'||chr(31)||'tttttttttt'||chr(30)||
'COMPANY'||chr(31)||'1000'||chr(30)||
'BUSINESS_TYPE'||chr(31)||'New'||chr(30)||
'CUSTOMER_ID'||chr(31)||'1723'||chr(30)||
'CURRENCY_CODE'||chr(31)||'USD'||chr(30)||
'PROBABILITY'||chr(31)||'100%'||chr(30)||
'BASE_EST_OPPORTUNITY_VALUE'||chr(31)||'0'||chr(30)||
'EST_OPPORTUNITY_VALUE'||chr(31)||'0'||chr(30)||
'MAIN_REPRESENTATIVE_ID'||chr(31)||'fffffff'||chr(30)||
'SOURCE_ID'||chr(31)||'Contract Services'||chr(30)||
'OPPORTUNITY_TYPE'||chr(31)||'Formal'||chr(30)||
'STAGE_ID'||chr(31)||'Won'||chr(30)||
'START_DATE'||chr(31)||'2020-08-01-00.00.00'||chr(30)||
'EXPIRATION_DATE'||chr(31)||'2020-08-02-00.00.00'||chr(30)||
'MARKET_CODE'||chr(31)||'03'||chr(30)||
'UPDATE_OPPRTUN_LINES'||chr(31)||'FALSE'||chr(30)||
'ADDRESS_SELECTED'||chr(31)||'TRUE'||chr(30)'''
p4_ = 'DO'

def create_PRF(p0_,p1_,p3_,p4_):
    print(p3_)
    dsn_tns = cx_Oracle.makedsn('XXXXXX.XX-1.local', '9999', service_name='DEV')
    conn = cx_Oracle.connect(user=r'MY_USER_NAME', password='PASSWORD', dsn=dsn_tns)
    cur = conn.cursor()
    cur.callproc('BUSINESS_OPPORTUNITY_API.NEW__',[p0_,p1_,p3_,p4_] )
    cur.close()
    conn.close()

create_PRF(p0_,p1_,p3_,p4_)

我收到的错误是:

Traceback (most recent call last): File "SPACE.py", line 40, in create_PRF(p0_,p1_,p2_,p3_,p4_) File "SPACE.py", line 33, in create_PRF cur.callproc('BUSINESS_OPPORTUNITY_API.NEW__',( p0_, p1_, p2_ , p3_ , p4_ )) cx_Oracle.DatabaseError: ORA-06550: line 1, column 7: PLS-00201: identifier 'BUSINESS_OPPORTUNITY_API.NEW__' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored


Tags: idcreatelinebusinessnulloraclecxp3

热门问题