Question

我确信,这是一件简单的事情,但我确实对人民党/民族解放军来说是新鲜事,我 st。

我撰写了一份简单的储存程序,以归还对客户的一些价值。批次,<代码>%rowtype s 不是作为保留的关键词而来的,而汇编者却把这些词说成是错误。

但是,它忽视了标明“条码”的全文。即使我试图将其减少到仅选择一栏,它仍然给我同样的错误。

create or replace
PROCEDURE GETCUSTOMER 
(
  arg_customerID demo_customers.customer_id%type,
  returnRec OUT demo_customers%rowtype
) 
AS
BEGIN
  SELECT  customer_id, cust_first_name, cust_last_name, cust_email
  INTO    returnRec
  FROM    demo_customers
  WHERE   customer_id = arg_customerID ;

END GETCUSTOMER;

Answer 1

如果你想选择百分数的ROWTYPE记录,那么你想要做的是SlectT *,而不是选择单列。

create or replace
PROCEDURE GETCUSTOMER 
(
  arg_customerID demo_customers.customer_id%type,
  returnRec OUT demo_customers%rowtype
) 
AS
BEGIN
  SELECT  *
  INTO    returnRec
  FROM    demo_customers
  WHERE   customer_id = arg_customerID ;

END GETCUSTOMER;

If you select 4 columns explicitly, Oracle expects you to have 4 variables to select those values into.

友情链接