带有字段名称的Oracle存储过程返回记录集(Oracle Stored Procedure Return Recordset with Field Names)

 我是Oracle和存储过程的新手。 我只想知道它是否可能（如在SQL Server中）将具有字段名称的记录集返回给外部程序。 我读了一些文件，但我不确定我是否走在正确的轨道上。 当我使用Sys_Refcursor时，我只能返回一个Field而不是我想要的那个。 
 
 我需要返回多个字段名称，我有一个输入参数。 
 
 在该程序的文档中，我有一个SQL Server的示例，我希望我的Oracle存储过程具有相同的： 
 
Use
Go
Set Ansi_Nulls ON
Go
Alter Procedure
   @InputLocation Varchar(255)
As
Begin
   Set Nocount On;
   select FirstName as '@FirstName', Company as '@Company' from dbo.company where Location = @InputLocation
End
 
 有什么建议我怎么做？ 如果您需要一些额外的信息，请告诉我。 谢谢。 
 
 /编辑： 
 
 我的示例代码（在第一步中不使用输入参数，仅用于生成输出以查看它是否有效）： 
 
create or replace 
PROCEDURE TEST_PROZEDUR1 (
  Input_Location IN Varchar2, 
  First_Name OUT SYS_Refcursor, 
  Company OUT Sys_Refcursor) IS 
BEGIN
  open First_Name For Select FirstName from dbo.company;
  open Company For Select Company from dbo.company;
END TEST_PROZEDUR1;

I am new to Oracle and Stored Procedures. I just would like to know if its possible, like in SQL Server, to return a recordset with Field Names to an extern program. I read some documentations but I'm not sure if I'm on the right track. When I use Sys_Refcursor I can only return one Field and not as many as I would like to.
 
I need to return multiple Field Names and I have one input parameter.
 
In the documentation of the program, i have an example for SQL Server and I would like to have the same for my Oracle Stored Procedure:
 
Use
Go
Set Ansi_Nulls ON
Go
Alter Procedure
   @InputLocation Varchar(255)
As
Begin
   Set Nocount On;
   select FirstName as '@FirstName', Company as '@Company' from dbo.company where Location = @InputLocation
End
 
Are there any suggestions how I can do that? If you need some additional informations just let me know. Thanks.
 
/edit:
 
My sample Code (without using the Input Parameter in the first step, just for generating Output to see if it works):
 
create or replace 
PROCEDURE TEST_PROZEDUR1 (
  Input_Location IN Varchar2, 
  First_Name OUT SYS_Refcursor, 
  Company OUT Sys_Refcursor) IS 
BEGIN
  open First_Name For Select FirstName from dbo.company;
  open Company For Select Company from dbo.company;
END TEST_PROZEDUR1;

原文：https://stackoverflow.com/questions/27704675