在Oracle PL/SQL中创建数据包，遇到报错：PLS-00103：出现符号“CREATE”,请问如何解决？

本人小白，我在创建基于存储过程的数据块时，第一次按照网上的教程，依葫芦画样创建成功后，运行也成功，但是手贱没有保存，也因为脑残有点飘，第二次自己创建时出现问题，后续把第一次成功做的样例拿出来再对照编写时，不断报错，最后重新把第一次做的样例拿出来已经无法运行，所以来此请教各位大佬。

先把我参考的网址挂出来：https://blog.csdn.net/weixin_33915554/article/details/85448269

接下来，我说一下问题：
我在Oracle的PL/SQL Developer中创建了一个Package: hek_ar_reciept_pg

包中代码贴出来如下：

create or replace package hek_ar_reciept_pg is
       type line_record_type is record(
        LINE_ID                          NUMBER,
        HEADER_ID                        NUMBER,
        CUSTOMER_TRX_ID                  NUMBER,
        APPLY_ACCOUNT                    NUMBER,
        APPLY_DATE                       DATE,
        GL_DATE                          DATE,
        DISCOUNT                         NUMBER,
        REVERSAL_GL_DATE                 DATE,
        AMOUNT_APPLIED_FROM              NUMBER,
        MATCH_FLAG                       VARCHAR2(30),
        APPLY_FLAG                       VARCHAR2(10),
        TRX_NUMBER                       VARCHAR2(30),
        INSTALLMENT                      NUMBER,
        AMOUNT_DUE_REMAINING             NUMBER,
        INVOICE_CURRENCY_CODE            VARCHAR2(15),
        CUSTOMER_NUMBER                  VARCHAR2(30),
        CUSTOMER_ID                      NUMBER,
        CUSTOMER_NAME                    VARCHAR2(50),
        TRX_CLASS_NAME                   VARCHAR2(4000),
        TRX_CLASS_CODE                   VARCHAR2(20),
        TRX_TYPE_NAME                    VARCHAR2(20),
        PURCHASE_ORDER                   VARCHAR2(50),
        CT_REFERENCE                     VARCHAR2(30),
        LOCATION_NAME                    VARCHAR2(40),
        BILL_TO_SITE_USE_ID              NUMBER,
        STATUS                           VARCHAR2(30),
        CASH_RECEIPT_ID                  NUMBER,
        PS_CUSTOMER_TRX_ID               NUMBER,
        TRX_BATCH_SOURCE_NAME            VARCHAR2(50),
        DUE_DATE                         DATE,
        TERM_ID                          NUMBER,
        CUST_TRX_TYPE_ID                 NUMBER,
        PROGRAM_APPLICATION_ID           NUMBER,
        PROGRAM_ID                       NUMBER,
        REQUEST_ID                       NUMBER,
        AMOUNT_DUE_ORIGINAL              NUMBER,
        AMOUNT_IN_DISPUTE                NUMBER,
        AMOUNT_LINE_ITEMS_ORIGINAL       NUMBER,
        ACCTD_AMOUNT_DUE_REMAINING       NUMBER,
        TRX_DATE                         DATE,
        APPLIED_PAYMENT_SCHEDULE_ID      NUMBER,
        CREATED_BY                       NUMBER,
        CREATION_DATE                    DATE,
        LAST_UPDATED_BY                  NUMBER,
        LAST_UPDATE_DATE                 DATE,
        LAST_UPDATE_LOGIN                NUMBER,
        ORG_ID                           NUMBER,
        ATTRIBUTE_CATEGORY               VARCHAR2(30),
        ATTRIBUTE1                       VARCHAR2(50),
        ATTRIBUTE2                       VARCHAR2(50),
        ATTRIBUTE3                       VARCHAR2(50),
        ATTRIBUTE4                       VARCHAR2(50),
        ATTRIBUTE5                       VARCHAR2(50),
        ATTRIBUTE6                       VARCHAR2(50),
        ATTRIBUTE7                       VARCHAR2(50),
        ATTRIBUTE8                       VARCHAR2(50),
        ATTRIBUTE9                       VARCHAR2(50),
        ATTRIBUTE10                      VARCHAR2(50),
        ATTRIBUTE11                      VARCHAR2(150),
        ATTRIBUTE12                      VARCHAR2(150),
        ATTRIBUTE13                      VARCHAR2(150),
        ATTRIBUTE14                      VARCHAR2(150),
        ATTRIBUTE15                      VARCHAR2(150)
       );

type lines_record_type is record(
        LINE_ID                          NUMBER,
        HEADER_ID                        NUMBER,
        CUSTOMER_TRX_ID                  NUMBER,
        APPLY_ACCOUNT                    NUMBER,
        APPLY_DATE                      DATE,
        GL_DATE                          DATE,
        DISCOUNT                        NUMBER,
        REVERSAL_GL_DATE DATE,
        AMOUNT_APPLIED_FROM NUMBER,
        MATCH_FLAG VARCHAR2(30),
        APPLY_FLAG VARCHAR2(10),
        CREATED_BY NUMBER,
        CREATION_DATE DATE,
        LAST_UPDATED_BY NUMBER,
        LAST_UPDATE_DATE DATE,
        LAST_UPDATE_LOGIN NUMBER,
        ORG_ID NUMBER,
        ATTRIBUTE_CATEGORY VARCHAR2(30),
        ATTRIBUTE1 VARCHAR2(50),
        ATTRIBUTE2 VARCHAR2(50),
        ATTRIBUTE3 VARCHAR2(50),
        ATTRIBUTE4 VARCHAR2(50),
        ATTRIBUTE5 VARCHAR2(50),
        ATTRIBUTE6 VARCHAR2(50),
        ATTRIBUTE7 VARCHAR2(50),
        ATTRIBUTE8 VARCHAR2(50),
        ATTRIBUTE9 VARCHAR2(50),
        ATTRIBUTE10 VARCHAR2(50),
        ATTRIBUTE11 VARCHAR2(150),
        ATTRIBUTE12 VARCHAR2(150),
        ATTRIBUTE13 VARCHAR2(150),
        ATTRIBUTE14 VARCHAR2(150),
        ATTRIBUTE15 VARCHAR2(150)
            );


      type line_ref_cursor is ref cursor return line_record_type;
      type line_table_type is table of lines_record_type index by binary_integer;

      procedure line_query(dmlset in out line_ref_cursor);
      procedure line_lock(dmlset in out line_table_type);
      procedure line_insert(dmlset in out line_table_type);
      procedure line_update(dmlset in out line_table_type);
      procedure line_delete(dmlset in out line_table_type);
end;


create or replace package body hek_ar_reciept_pg is


      procedure line_query(dmlset in out line_ref_cursor) is
      begin
          open dmlset for
          select line_id,
                 header_id,
                 customer_trx_id,
                 apply_account,
                 apply_date,
                 gl_date,
                 discount,
                 reversal_gl_date,
                 amount_applied_from,
                 match_flag,
                 apply_flag,
                 trx_number,
                 installment,
                 amount_due_remaining,
                 invoice_currency_code,
                 customer_number,
                 customer_id,
                 customer_name,
                 trx_class_name,
                 trx_class_code,
                 trx_type_name,
                 purchase_order,
                 ct_reference,
                 location_name,
                 bill_to_site_use_id,
                 status,
                 cash_receipt_id,
                 ps_customer_trx_id,
                 trx_batch_source_name,
                 due_date,
                 term_id,
                 cust_trx_type_id,
                 program_application_id,
                 program_id,
                 request_id,
                 amount_due_original,
                 amount_in_dispute,
                 amount_line_items_original,
                 acctd_amount_due_remaining,
                 trx_date,
                 applied_payment_schedule_id,
                 created_by,
                 creation_date,
                 last_updated_by,
                 last_update_date,
                 last_update_login,
                 org_id,
                 attribute_category,
                 attribute1,
                 attribute2,
                 attribute3,
                 attribute4,
                 attribute5,
                 attribute6,
                 attribute7,
                 attribute8,
                 attribute9,
                 attribute10,
                 attribute11,
                 attribute12,
                 attribute13,
                 attribute14,
                 attribute15
            from hek_ar_reciept_lines_v;
      end;

      procedure line_lock(dmlset in out line_table_type) is
           l_line_id number;
      begin
           select line_id
             into l_line_id
             from hek_ar_reciept_lines_all
            where line_id = dmlset(1).line_id
              for update;
      end;

      procedure line_insert(dmlset in out line_table_type) is
      begin
           insert into hek_ar_reciept_lines_all(LINE_ID,
                                                HEADER_ID,
                                                CUSTOMER_TRX_ID,
                                                APPLY_ACCOUNT,
                                                APPLY_DATE,
                                                GL_DATE,
                                                DISCOUNT,
                                                REVERSAL_GL_DATE,
                                                AMOUNT_APPLIED_FROM,
                                                MATCH_FLAG,
                                                APPLY_FLAG,
                                                CREATED_BY,
                                                CREATION_DATE,
                                                LAST_UPDATED_BY,
                                                LAST_UPDATE_DATE,
                                                LAST_UPDATE_LOGIN,
                                                ORG_ID,
                                                ATTRIBUTE_CATEGORY,
                                                ATTRIBUTE1,
                                                ATTRIBUTE2,
                                                ATTRIBUTE3,
                                                ATTRIBUTE4,
                                                ATTRIBUTE5,
                                                ATTRIBUTE6,
                                                ATTRIBUTE7,
                                                ATTRIBUTE8,
                                                ATTRIBUTE9,
                                                ATTRIBUTE10,
                                                ATTRIBUTE11,
                                                ATTRIBUTE12,
                                                ATTRIBUTE13,
                                                ATTRIBUTE14,
                                                ATTRIBUTE15)
                                         values(dmlset(1).LINE_ID,
                                                dmlset(1).HEADER_ID,
                                                dmlset(1).CUSTOMER_TRX_ID,
                                                dmlset(1).APPLY_ACCOUNT,
                                                dmlset(1).APPLY_DATE,
                                                dmlset(1).GL_DATE,
                                                dmlset(1).DISCOUNT,
                                                dmlset(1).REVERSAL_GL_DATE,
                                                dmlset(1).AMOUNT_APPLIED_FROM,
                                                dmlset(1).MATCH_FLAG,
                                                dmlset(1).APPLY_FLAG,
                                                dmlset(1).CREATED_BY,
                                                dmlset(1).CREATION_DATE,
                                                dmlset(1).LAST_UPDATED_BY,
                                                dmlset(1).LAST_UPDATE_DATE,
                                                dmlset(1).LAST_UPDATE_LOGIN,
                                                dmlset(1).ORG_ID,
                                                dmlset(1).ATTRIBUTE_CATEGORY,
                                                dmlset(1).ATTRIBUTE1,
                                                dmlset(1).ATTRIBUTE2,
                                                dmlset(1).ATTRIBUTE3,
                                                dmlset(1).ATTRIBUTE4,
                                                dmlset(1).ATTRIBUTE5,
                                                dmlset(1).ATTRIBUTE6,
                                                dmlset(1).ATTRIBUTE7,
                                                dmlset(1).ATTRIBUTE8,
                                                dmlset(1).ATTRIBUTE9,
                                                dmlset(1).ATTRIBUTE10,
                                                dmlset(1).ATTRIBUTE11,
                                                dmlset(1).ATTRIBUTE12,
                                                dmlset(1).ATTRIBUTE13,
                                                dmlset(1).ATTRIBUTE14,
                                                dmlset(1).ATTRIBUTE15);
      end;

      procedure line_update(dmlset in out line_table_type) is
      begin
          update hek_ar_reciept_lines_all
             set HEADER_ID = dmlset(1).HEADER_ID,--LINE_ID = dmlset(1).LINE_ID,
                 CUSTOMER_TRX_ID = dmlset(1).CUSTOMER_TRX_ID,
                 APPLY_ACCOUNT = dmlset(1).APPLY_ACCOUNT,
                 APPLY_DATE = dmlset(1).APPLY_DATE,
                 GL_DATE = dmlset(1).GL_DATE,
                 DISCOUNT = dmlset(1).DISCOUNT,
                 REVERSAL_GL_DATE = dmlset(1).REVERSAL_GL_DATE,
                 AMOUNT_APPLIED_FROM = dmlset(1).AMOUNT_APPLIED_FROM,
                 MATCH_FLAG = dmlset(1).MATCH_FLAG,
                 APPLY_FLAG = dmlset(1).APPLY_FLAG,
                 CREATED_BY = dmlset(1).CREATED_BY,
                 CREATION_DATE = dmlset(1).CREATION_DATE,
                 LAST_UPDATED_BY = dmlset(1).LAST_UPDATED_BY,
                 LAST_UPDATE_DATE = dmlset(1).LAST_UPDATE_DATE,
                 LAST_UPDATE_LOGIN = dmlset(1).LAST_UPDATE_LOGIN,
                 ORG_ID = dmlset(1).ORG_ID,
                 ATTRIBUTE_CATEGORY = dmlset(1).ATTRIBUTE_CATEGORY,
                 ATTRIBUTE1 = dmlset(1).ATTRIBUTE1,
                 ATTRIBUTE2 = dmlset(1).ATTRIBUTE2,
                 ATTRIBUTE3 = dmlset(1).ATTRIBUTE3,
                 ATTRIBUTE4 = dmlset(1).ATTRIBUTE4,
                 ATTRIBUTE5 = dmlset(1).ATTRIBUTE5,
                 ATTRIBUTE6 = dmlset(1).ATTRIBUTE6,
                 ATTRIBUTE7 = dmlset(1).ATTRIBUTE7,
                 ATTRIBUTE8 = dmlset(1).ATTRIBUTE8,
                 ATTRIBUTE9 = dmlset(1).ATTRIBUTE9,
                 ATTRIBUTE10 = dmlset(1).ATTRIBUTE10,
                 ATTRIBUTE11 = dmlset(1).ATTRIBUTE11,
                 ATTRIBUTE12 = dmlset(1).ATTRIBUTE12,
                 ATTRIBUTE13 = dmlset(1).ATTRIBUTE13,
                 ATTRIBUTE14 = dmlset(1).ATTRIBUTE14,
                 ATTRIBUTE15 = dmlset(1).ATTRIBUTE15
            where line_id = dmlset(1).line_id;
      end;

      procedure line_delete(dmlset in out line_table_type) is
      begin
          delete from hek_ar_reciept_lines_all
                where line_id = dmlset(1).line_id;
      end;
end;

但是执行后，代码第118行出现报错
118：create or replace package body hek_ar_reciept_pg is

错误为：118 PLS-00103：出现符号“CREATE”
图片说明

(这里代码行数118是我现在电脑上的行数，对照截图可能有一两行空白行的出入)

针对这个错误，我看了好多帖子，但是始终有错，后来，我觉得饭一口一口吃，从第118行开始全部删掉，只留下上面line_record_type记录部分，后成功运行，无报错，
图片说明

但是，这个时候，我在Oracle Forms builder中创建数据库向导的时候，发现在输入过程的时候，我输入：hek_ar_reciept_pg.line_query或hek_ar_reciept_pg.line_record，刷新的时候，发现报错 FRM-10760：描述存储过程时遇到错误，
图片说明
最后重新把第一次做的样例拿出来已经无法运行，所以来此请教各位大佬。

先把我参考的网址挂出来：https://blog.csdn.net/weixin_33915554/article/details/85448269

接下来，我说一下问题：
我在Oracle的PL/SQL Developer中创建了一个Package: hek_ar_reciept_pg

包中代码贴出来如下：

create or replace package hek_ar_reciept_pg is
       type line_record_type is record(
        LINE_ID                          NUMBER,
        HEADER_ID                        NUMBER,
        CUSTOMER_TRX_ID                  NUMBER,
        APPLY_ACCOUNT                    NUMBER,
        APPLY_DATE                       DATE,
        GL_DATE                          DATE,
        DISCOUNT                         NUMBER,
        REVERSAL_GL_DATE                 DATE,
        AMOUNT_APPLIED_FROM              NUMBER,
        MATCH_FLAG                       VARCHAR2(30),
        APPLY_FLAG                       VARCHAR2(10),
        TRX_NUMBER                       VARCHAR2(30),
        INSTALLMENT                      NUMBER,
        AMOUNT_DUE_REMAINING             NUMBER,
        INVOICE_CURRENCY_CODE            VARCHAR2(15),
        CUSTOMER_NUMBER                  VARCHAR2(30),
        CUSTOMER_ID                      NUMBER,
        CUSTOMER_NAME                    VARCHAR2(50),
        TRX_CLASS_NAME                   VARCHAR2(4000),
        TRX_CLASS_CODE                   VARCHAR2(20),
        TRX_TYPE_NAME                    VARCHAR2(20),
        PURCHASE_ORDER                   VARCHAR2(50),
        CT_REFERENCE                     VARCHAR2(30),
        LOCATION_NAME                    VARCHAR2(40),
        BILL_TO_SITE_USE_ID              NUMBER,
        STATUS                           VARCHAR2(30),
        CASH_RECEIPT_ID                  NUMBER,
        PS_CUSTOMER_TRX_ID               NUMBER,
        TRX_BATCH_SOURCE_NAME            VARCHAR2(50),
        DUE_DATE                         DATE,
        TERM_ID                          NUMBER,
        CUST_TRX_TYPE_ID                 NUMBER,
        PROGRAM_APPLICATION_ID           NUMBER,
        PROGRAM_ID                       NUMBER,
        REQUEST_ID                       NUMBER,
        AMOUNT_DUE_ORIGINAL              NUMBER,
        AMOUNT_IN_DISPUTE                NUMBER,
        AMOUNT_LINE_ITEMS_ORIGINAL       NUMBER,
        ACCTD_AMOUNT_DUE_REMAINING       NUMBER,
        TRX_DATE                         DATE,
        APPLIED_PAYMENT_SCHEDULE_ID      NUMBER,
        CREATED_BY                       NUMBER,
        CREATION_DATE                    DATE,
        LAST_UPDATED_BY                  NUMBER,
        LAST_UPDATE_DATE                 DATE,
        LAST_UPDATE_LOGIN                NUMBER,
        ORG_ID                           NUMBER,
        ATTRIBUTE_CATEGORY               VARCHAR2(30),
        ATTRIBUTE1                       VARCHAR2(50),
        ATTRIBUTE2                       VARCHAR2(50),
        ATTRIBUTE3                       VARCHAR2(50),
        ATTRIBUTE4                       VARCHAR2(50),
        ATTRIBUTE5                       VARCHAR2(50),
        ATTRIBUTE6                       VARCHAR2(50),
        ATTRIBUTE7                       VARCHAR2(50),
        ATTRIBUTE8                       VARCHAR2(50),
        ATTRIBUTE9                       VARCHAR2(50),
        ATTRIBUTE10                      VARCHAR2(50),
        ATTRIBUTE11                      VARCHAR2(150),
        ATTRIBUTE12                      VARCHAR2(150),
        ATTRIBUTE13                      VARCHAR2(150),
        ATTRIBUTE14                      VARCHAR2(150),
        ATTRIBUTE15                      VARCHAR2(150)
       );

type lines_record_type is record(
        LINE_ID                          NUMBER,
        HEADER_ID                        NUMBER,
        CUSTOMER_TRX_ID                  NUMBER,
        APPLY_ACCOUNT                    NUMBER,
        APPLY_DATE                      DATE,
        GL_DATE                          DATE,
        DISCOUNT                        NUMBER,
        REVERSAL_GL_DATE DATE,
        AMOUNT_APPLIED_FROM NUMBER,
        MATCH_FLAG VARCHAR2(30),
        APPLY_FLAG VARCHAR2(10),
        CREATED_BY NUMBER,
        CREATION_DATE DATE,
        LAST_UPDATED_BY NUMBER,
        LAST_UPDATE_DATE DATE,
        LAST_UPDATE_LOGIN NUMBER,
        ORG_ID NUMBER,
        ATTRIBUTE_CATEGORY VARCHAR2(30),
        ATTRIBUTE1 VARCHAR2(50),
        ATTRIBUTE2 VARCHAR2(50),
        ATTRIBUTE3 VARCHAR2(50),
        ATTRIBUTE4 VARCHAR2(50),
        ATTRIBUTE5 VARCHAR2(50),
        ATTRIBUTE6 VARCHAR2(50),
        ATTRIBUTE7 VARCHAR2(50),
        ATTRIBUTE8 VARCHAR2(50),
        ATTRIBUTE9 VARCHAR2(50),
        ATTRIBUTE10 VARCHAR2(50),
        ATTRIBUTE11 VARCHAR2(150),
        ATTRIBUTE12 VARCHAR2(150),
        ATTRIBUTE13 VARCHAR2(150),
        ATTRIBUTE14 VARCHAR2(150),
        ATTRIBUTE15 VARCHAR2(150)
            );


      type line_ref_cursor is ref cursor return line_record_type;
      type line_table_type is table of lines_record_type index by binary_integer;

      procedure line_query(dmlset in out line_ref_cursor);
      procedure line_lock(dmlset in out line_table_type);
      procedure line_insert(dmlset in out line_table_type);
      procedure line_update(dmlset in out line_table_type);
      procedure line_delete(dmlset in out line_table_type);
end;


create or replace package body hek_ar_reciept_pg is


      procedure line_query(dmlset in out line_ref_cursor) is
      begin
          open dmlset for
          select line_id,
                 header_id,
                 customer_trx_id,
                 apply_account,
                 apply_date,
                 gl_date,
                 discount,
                 reversal_gl_date,
                 amount_applied_from,
                 match_flag,
                 apply_flag,
                 trx_number,
                 installment,
                 amount_due_remaining,
                 invoice_currency_code,
                 customer_number,
                 customer_id,
                 customer_name,
                 trx_class_name,
                 trx_class_code,
                 trx_type_name,
                 purchase_order,
                 ct_reference,
                 location_name,
                 bill_to_site_use_id,
                 status,
                 cash_receipt_id,
                 ps_customer_trx_id,
                 trx_batch_source_name,
                 due_date,
                 term_id,
                 cust_trx_type_id,
                 program_application_id,
                 program_id,
                 request_id,
                 amount_due_original,
                 amount_in_dispute,
                 amount_line_items_original,
                 acctd_amount_due_remaining,
                 trx_date,
                 applied_payment_schedule_id,
                 created_by,
                 creation_date,
                 last_updated_by,
                 last_update_date,
                 last_update_login,
                 org_id,
                 attribute_category,
                 attribute1,
                 attribute2,
                 attribute3,
                 attribute4,
                 attribute5,
                 attribute6,
                 attribute7,
                 attribute8,
                 attribute9,
                 attribute10,
                 attribute11,
                 attribute12,
                 attribute13,
                 attribute14,
                 attribute15
            from hek_ar_reciept_lines_v;
      end;

      procedure line_lock(dmlset in out line_table_type) is
           l_line_id number;
      begin
           select line_id
             into l_line_id
             from hek_ar_reciept_lines_all
            where line_id = dmlset(1).line_id
              for update;
      end;

      procedure line_insert(dmlset in out line_table_type) is
      begin
           insert into hek_ar_reciept_lines_all(LINE_ID,
                                                HEADER_ID,
                                                CUSTOMER_TRX_ID,
                                                APPLY_ACCOUNT,
                                                APPLY_DATE,
                                                GL_DATE,
                                                DISCOUNT,
                                                REVERSAL_GL_DATE,
                                                AMOUNT_APPLIED_FROM,
                                                MATCH_FLAG,
                                                APPLY_FLAG,
                                                CREATED_BY,
                                                CREATION_DATE,
                                                LAST_UPDATED_BY,
                                                LAST_UPDATE_DATE,
                                                LAST_UPDATE_LOGIN,
                                                ORG_ID,
                                                ATTRIBUTE_CATEGORY,
                                                ATTRIBUTE1,
                                                ATTRIBUTE2,
                                                ATTRIBUTE3,
                                                ATTRIBUTE4,
                                                ATTRIBUTE5,
                                                ATTRIBUTE6,
                                                ATTRIBUTE7,
                                                ATTRIBUTE8,
                                                ATTRIBUTE9,
                                                ATTRIBUTE10,
                                                ATTRIBUTE11,
                                                ATTRIBUTE12,
                                                ATTRIBUTE13,
                                                ATTRIBUTE14,
                                                ATTRIBUTE15)
                                         values(dmlset(1).LINE_ID,
                                                dmlset(1).HEADER_ID,
                                                dmlset(1).CUSTOMER_TRX_ID,
                                                dmlset(1).APPLY_ACCOUNT,
                                                dmlset(1).APPLY_DATE,
                                                dmlset(1).GL_DATE,
                                                dmlset(1).DISCOUNT,
                                                dmlset(1).REVERSAL_GL_DATE,
                                                dmlset(1).AMOUNT_APPLIED_FROM,
                                                dmlset(1).MATCH_FLAG,
                                                dmlset(1).APPLY_FLAG,
                                                dmlset(1).CREATED_BY,
                                                dmlset(1).CREATION_DATE,
                                                dmlset(1).LAST_UPDATED_BY,
                                                dmlset(1).LAST_UPDATE_DATE,
                                                dmlset(1).LAST_UPDATE_LOGIN,
                                                dmlset(1).ORG_ID,
                                                dmlset(1).ATTRIBUTE_CATEGORY,
                                                dmlset(1).ATTRIBUTE1,
                                                dmlset(1).ATTRIBUTE2,
                                                dmlset(1).ATTRIBUTE3,
                                                dmlset(1).ATTRIBUTE4,
                                                dmlset(1).ATTRIBUTE5,
                                                dmlset(1).ATTRIBUTE6,
                                                dmlset(1).ATTRIBUTE7,
                                                dmlset(1).ATTRIBUTE8,
                                                dmlset(1).ATTRIBUTE9,
                                                dmlset(1).ATTRIBUTE10,
                                                dmlset(1).ATTRIBUTE11,
                                                dmlset(1).ATTRIBUTE12,
                                                dmlset(1).ATTRIBUTE13,
                                                dmlset(1).ATTRIBUTE14,
                                                dmlset(1).ATTRIBUTE15);
      end;

      procedure line_update(dmlset in out line_table_type) is
      begin
          update hek_ar_reciept_lines_all
             set HEADER_ID = dmlset(1).HEADER_ID,--LINE_ID = dmlset(1).LINE_ID,
                 CUSTOMER_TRX_ID = dmlset(1).CUSTOMER_TRX_ID,
                 APPLY_ACCOUNT = dmlset(1).APPLY_ACCOUNT,
                 APPLY_DATE = dmlset(1).APPLY_DATE,
                 GL_DATE = dmlset(1).GL_DATE,
                 DISCOUNT = dmlset(1).DISCOUNT,
                 REVERSAL_GL_DATE = dmlset(1).REVERSAL_GL_DATE,
                 AMOUNT_APPLIED_FROM = dmlset(1).AMOUNT_APPLIED_FROM,
                 MATCH_FLAG = dmlset(1).MATCH_FLAG,
                 APPLY_FLAG = dmlset(1).APPLY_FLAG,
                 CREATED_BY = dmlset(1).CREATED_BY,
                 CREATION_DATE = dmlset(1).CREATION_DATE,
                 LAST_UPDATED_BY = dmlset(1).LAST_UPDATED_BY,
                 LAST_UPDATE_DATE = dmlset(1).LAST_UPDATE_DATE,
                 LAST_UPDATE_LOGIN = dmlset(1).LAST_UPDATE_LOGIN,
                 ORG_ID = dmlset(1).ORG_ID,
                 ATTRIBUTE_CATEGORY = dmlset(1).ATTRIBUTE_CATEGORY,
                 ATTRIBUTE1 = dmlset(1).ATTRIBUTE1,
                 ATTRIBUTE2 = dmlset(1).ATTRIBUTE2,
                 ATTRIBUTE3 = dmlset(1).ATTRIBUTE3,
                 ATTRIBUTE4 = dmlset(1).ATTRIBUTE4,
                 ATTRIBUTE5 = dmlset(1).ATTRIBUTE5,
                 ATTRIBUTE6 = dmlset(1).ATTRIBUTE6,
                 ATTRIBUTE7 = dmlset(1).ATTRIBUTE7,
                 ATTRIBUTE8 = dmlset(1).ATTRIBUTE8,
                 ATTRIBUTE9 = dmlset(1).ATTRIBUTE9,
                 ATTRIBUTE10 = dmlset(1).ATTRIBUTE10,
                 ATTRIBUTE11 = dmlset(1).ATTRIBUTE11,
                 ATTRIBUTE12 = dmlset(1).ATTRIBUTE12,
                 ATTRIBUTE13 = dmlset(1).ATTRIBUTE13,
                 ATTRIBUTE14 = dmlset(1).ATTRIBUTE14,
                 ATTRIBUTE15 = dmlset(1).ATTRIBUTE15
            where line_id = dmlset(1).line_id;
      end;

      procedure line_delete(dmlset in out line_table_type) is
      begin
          delete from hek_ar_reciept_lines_all
                where line_id = dmlset(1).line_id;
      end;
end;

但是执行后，代码第118行出现报错
118：create or replace package body hek_ar_reciept_pg is

错误为：118 PLS-00103：出现符号“CREATE”
图片说明

(这里代码行数118是我现在电脑上的行数，对照截图可能有一两行空白行的出入)

但是，这个时候，我在Oracle Forms builder中创建数据库向导的时候，发现在输入过程的时候，我输入：hek_ar_reciept_pg.line_query或hek_ar_reciept_pg.line_record，刷新的时候，发现报错 FRM-10760：描述存储过程时遇到错误，
图片说明
接下来始终卡在这里，进退不得，一方面无法进行数据块的创建，另一方面在Oracle PL/SQL developer中也没什么好办法继续下去，麻烦各位大佬讲解一下，指导一二，感激不尽！

以上是第一次的问题，后面听取了各位意见后，我通过重建数据库，初步实现了目的，但是实际上，还是有些问题的，比如：我在数据库编写数据包时，遇到如下问题：
图片说明

虽然依旧能跑，但是毫无疑问，功能是有问题的
如下：

请问，在PL/SQL中的数据包中，怎么修改才能解决这个问题？请求指点，谢谢！

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
threenewbee 2020-02-26 11:57
关注
分开来，参考 https://blog.csdn.net/WXB52112181314/article/details/80865631
至于FRM-10760你得检查你的存储过程
感觉你的数据库有点混乱了，建议重新创建一个库，禁掉存储过程、触发器，然后导入

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

在Oracle PL/SQL中创建数据包，遇到报错：PLS-00103：出现符号“CREATE”,请问如何解决？ oracle
2020-02-26 11:51

回答 1 已采纳分开来，参考 https://blog.csdn.net/WXB52112181314/article/details/80865631 至于FRM-10760你得检查你的存储过程感觉你的数据库
Oracle使用动态sql语句创建用户报错：ORA-00922: 选项缺失或无效 oracle
2022-11-20 17:23

回答 1 已采纳语句关键字identified错了。 create user major identified by admin.CREATE USER major' ||pmajorno.majorno||' I
oracle模糊查询报错：ORA-01425 转义符必须是长度为 1 的字符串 oracle 有问必答
2021-06-21 18:19

回答 2 已采纳已解决解决方式：通过将参数CURSOR_SHARING更改为EXACT alter system set cursor_sharing=EXACT scope=both;
创建oracle type类型,转载：oracle 自定义类型 type / create type
2021-05-01 04:47

NET科隆的博客一：Oracle中的类型有很多种，主要可以分为以下几类：1、字符串类型。如：char、nchar、varchar2、nvarchar2。2、数值类型。如：int、number(p,s)、integer、smallint。3、日期类型。如：date、interval、timestamp...
python 执行oracle sql 报错 ORA-00900: invalid SQL statement oracle python sql 有问必答
2022-04-04 16:44

回答 5 已采纳来源：https://blog.csdn.net/weixin_39855998/article/details/129014190 # _*_ coding:utf-8 _*_ import os
oracle报错pls00103出现字符create oracle sql
2021-12-08 10:55

回答 2 已采纳两个存储过程之间加个 / CREATE OR REPLACE PROCEDURE println(str varchar) AS BEGIN dbms_output.put_line(str);
oracle启动报错：ora-01078,01565,17503,15056 oracle 数据库
2023-03-02 07:51

回答 3 已采纳从问题描述看，最可能的情况是asm磁盘没有使用udev绑定。磁盘周期性被刷新属主，导致asm磁盘组不正常，数据库失败。磁盘是/dev/sdx ，使用 chmod grid：asamdmin /dev
ORA-报错解释
2022-05-17 12:00

擀掉上帝的博客 ORA-报错解释
java.sql.SQLSyntaxErrorException: ORA-00932: 数据类型不一致 intellij-idea java oracle
2021-08-23 11:21

回答 1 已采纳查了一下数据库结构发现跟正式库虽然字段和数据都一样，但是我是用IDEA导出正式库的CSV类型表，导入到测试库中。正式库中的表字段类型为VARCHAR2类型，发现测试库的表字段类型大部分为CLOB类型，
python cxOracle库中使用sql语句报错ORA-00933:SQL命令未正确结束 python sql 数据库
2021-12-01 15:10

回答 1 已采纳 oracle 一直到 12g ，貌似没有 drop table if exists 这种用法。
Oracle存储过程报错：pls 00201 必须声明标识符 oracle sql
2018-04-11 13:04

回答 1 已采纳 test_sse 写成test_see了，一个字母不对
转：oracle-ora 各种sql异常描述
2015-08-21 19:43

CBoom的博客 java.sql.SQLException错误！ ORA-00904: --invalid column name 无效列名 ORA-00942: --table or view does not exist 表或者视图不存在 ORA-01400: --cannot insert NULL into () 不能将空值插入 ORA...
ORACLE触发器,报错：创建成功编译错误 oracle sql 数据库
2022-09-05 15:03

回答 2 已采纳两个表的表结构给一下我猜，在你的“tc_ggm_file”表里，没有“tc_gge01”这个字段，所以 “:new.tc_gge01”这个引用是错误的。建议换个工具，使用plsql developer
【Oracle】Oracle错误编码大全
2021-12-30 15:36

兮动人的博客【Oracle】Oracle错误编码大全
oracle错误(一) ORA-各种常见java.sql.SQLException小结
2015-06-05 11:24

小米加大炮的博客 ORA-00904: --invalid column name 无效列名 ORA-00942: --table or view does not exist 表或者视图不存在 ORA-01400: --cannot insert NULL into () 不能将空值插入 ...ORA-00933:　--SQL 命令未正确结束 ORA-0172
没有解决我的问题, 去提问

悬赏问题

¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
¥15 （希望可以解决问题）ma和mb文件无法正常打开，打开后是空白，但是有正常内存占用，但可以在打开Maya应用程序后打开场景ma和mb格式。
¥15 绘制多分类任务的roc曲线时只画出了一类的roc，其它的auc显示为nan
¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
¥20 腾讯企业邮箱邮件可以恢复么
¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗？
¥15 错误 LNK2001 无法解析的外部符号
¥50 安装pyaudiokits失败
¥15 计组这些题应该咋做呀
¥60 更换迈创SOL6M4AE卡的时候，驱动要重新装才能使用，怎么解决？

在Oracle PL/SQL中创建数据包，遇到报错：PLS-00103：出现符号“CREATE”,请问如何解决？

1条回答 默认 最新

悬赏问题

1条回答默认最新