c調用存儲過程
A. 如何調用存儲過程，有返回值的，有參數的，存儲過程中調用存儲過程
create procere proc_a as declare b int; c varchar2(10); begin proc_b(b, c); dbms_output.put_line (c); end procere a; 你照我這個寫吧 proc_b(b, c); proc_b是你調用的帶返回參數的存儲過程 b是輸入變數，c是輸出變數
B. c程序該怎麼樣調用oracle存儲過程並獲取存儲過程中的輸出參數的值
我以前這樣用pro*c 這樣玩的，僅供參考
EXEC sql EXECUTE
DECLARE
lsid varchar2(60);
lss_this_error_code number;
BEGIN
proctest(:ls_name,lsid); --ls_name 輸入參數 lss_id 輸出
:chId := lsid;-- lsid 輸出返回給C變數chId
END;
END-EXEC;
C. 如何通過c或c++調用存儲過程
給個例子給你看下：
...
_CommandPtr m_cmdptr;
m_cmdptr.CreateInstance(__uuidof( Command ) );
_ParameterPtr inParam2=NULL;
_ParameterPtr inParam3=NULL;
_ParameterPtr inParam4=NULL;
_ParameterPtr outParam1=NULL;
_ParameterPtr outParam2=NULL;
_ParameterPtr outParam3=NULL;
inParam2.CreateInstance(__uuidof(Parameter));
inParam3.CreateInstance(__uuidof(Parameter));
inParam4.CreateInstance(__uuidof(Parameter));
outParam1.CreateInstance(__uuidof(Parameter));
outParam2.CreateInstance(__uuidof(Parameter));
outParam3.CreateInstance(__uuidof(Parameter));
m_cmdptr->ActiveConnection=m_pConnection;
m_cmdptr->CommandType=adCmdStoredProc;
m_cmdptr->CommandText=_bstr_t("proc_XXX");//存儲過程的名稱
//輸入參數
inParam2=m_cmdptr->CreateParameter(_bstr_t("@P1"),adVarChar,adParamInput,32,_bstr_t(P1));
m_cmdptr->Parameters->Append(inParam2);
inParam3=m_cmdptr->CreateParameter(_bstr_t("@P2"),adVarChar,adParamInput,20,_bstr_t(P2));
m_cmdptr->Parameters->Append(inParam3);
//輸出參數
outParam1=m_cmdptr->CreateParameter("@P4",adInteger,adParamOutput,sizeof(int));
m_cmdptr->Parameters->Append(outParam1);
outParam2=m_cmdptr->CreateParameter("@P5",adInteger,adParamOutput,sizeof(int));
m_cmdptr->Parameters->Append(outParam2);
outParam3=m_cmdptr->CreateParameter(_bstr_t("@P6"),adVarChar,adParamOutput,20,_bstr_t(P6));
m_cmdptr->Parameters->Append(outParam3);
//執行
m_cmdptr->Execute(NULL,NULL,adCmdStoredProc);
//取返回值
long p1=m_cmdptr->Parameters->GetItem("@P4")->Value;
long p2=m_cmdptr->Parameters->GetItem("@P5")->Value;
VARIANT vtP6 =m_cmdptr->Parameters->GetItem("@P6")->Value;
if (vtP6.vt != VT_NULL)
strcpy(tp,(_bstr_t)vtP6);
m_cmdptr.Detach;
D. linux-c 嵌入式SQL如何調用存儲過程
EXEC SQL CALL TEST_PROC(: test_str);
EXEC SQL COMMIT;
應該是這樣調用，你試試
E. 求大神：C語言如何執行SQL sever的存儲過程
執行帶參數的存儲過程的方法如下：
Exec sp_configure 'allow updates',1 --允許更新系統表。
exec dbo.User_ChangeObjectOwnerBatch 'OldOwner','dbo'
以上是兩個例子。
SQL Server中執行帶參數的存儲過程的方法是：
EXEC 存儲過程名字 '參數1','參數2',數值參數
EXEC 是一個關鍵字。
字元串參數使用單引號括起來，數值參數不需要使用單引號
F. 如何在VC中調用存儲過程
定義好一個Connection連接,然後再產生一個Command對象,利用Command 對象進行存儲過程調用
_ConnectionPtr m_Conn;
_CommandPtr m_Command
_variant_t vNULL;//定義為無參數
vNULL.vt = VT_ERROR;
vNULL.scode = DISP_E_PARAMNOTFOUND
m_Conn.CreateInstance( __uuidof( ADODB::Connection ));//初始化一個連接
m_Command.CreateInstance(__uuidof( ADODB::Command));;//初始化一個Command
m_Conn->Open("Provider=sqloledb;Data Source=yjf;Initial Catalog=pubs;User ID=sa;Password=sa","","",adModeUnknown);//在這里用你直接的Connection連接語句
_bstr_t sp_execstr;
sp_execstr="Exec sp_name";//sp_name為存儲過程名,這句話應該可以在SQL Server中直接執行的
m_Command->ActiveConnection=m_Conn;
m_Command->m_CommandTxt=sp_execstr;
m_pRecordset = m_pCommand->Execute(&vNULL,&vNULL,adCmdText);
**********************************************************************************
_ConnectionPtr m_pConnection;
_CommandPtr m_pCommand;
//.cpp中在函數中執行
//建立ado連接
HRESULT hr;
hr=m_pConnection.CreateInstance(__uuidof(Connection));
try
{
if(SUCCEEDED(hr))
{
hr=m_pConnection->Open(_bstr_t(L"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Viper;Data Source=Viper"),_bstr_t (L"sa"),_bstr_t (L""),adModeUnknown);
}
}
catch(_com_error & err)
{
AfxMessageBox(err.Description(),MB_OK,0);
AfxMessageBox(err.ErrorMessage(),MB_OK,0);
AfxMessageBox("無法連接SQL SERVER 伺服器，程序將退出。請檢查網路設備",MB_OK,0);
exit(0);
}
//執行儲存過程
CString cvar1,cvar2;
int cvar3;
cvar1=」ddd」;
cvar2=」";
cvar3=0;
try
{
m_pCommand.CreateInstance(__uuidof(Command));
m_pCommand->ActiveConnection=app->m_pConnection;
m_pCommand->CommandType=adCmdStoredProc;
m_pCommand->CommandText=_bstr_t(」pr_zs_dzdy」);
_variant_t vvar1,vvar2,vvar3;
vvar1=_variant_t(_bstr_t(cvar1));
vvar2=_variant_t(_bstr_t(cvar2));
vvar3=_variant_t(cvar3);
_ParameterPtr mp_var1,mp_var2,mp_var3;
mp_var1.CreateInstance(__uuidof(Parameter));
mp_var2.CreateInstance(__uuidof(Parameter));
mp_var3.CreateInstance(__uuidof(Parameter));
mp_var1=m_pCommand->CreateParameter
(
_bstr_t(」var1″),
adVarChar,
adParamInput,
3,
vvar1
);
m_pCommand->Parameters->Append(mp_var1);
mp_var2=m_pCommand->CreateParameter
(
_bstr_t(」var2″),
adVarChar,
adParamOutput,
3,
vvar2
);
m_pCommand->Parameters->Append(mp_var2);
mp_var3=m_pCommand->CreateParameter
(
_bstr_t(」var3″),
adIntger,
adParamOutput,
9,
vvar3
);
m_pCommand->Parameters->Append(mp_var3);
_variant_t vNull;
vNull.vt=VT_ERROR;
vNull.scode=DISP_E_PARAMNOTFOUND;
m_pCommand->Execute(&vNull,&vNull,adCmdStoredProc);
cvar2=mp_var2->Value.bstrVal;
cvar3=mp_var3->Value;
}
catch(_com_error &error)
{
MessageBox(error.ErrorMessage(),」ADO錯誤!」);
MessageBox(error.Description(),」ADO錯誤!」);
}
********************************************************************************
如果用ODBC訪問資料庫的話，可參考下列代碼：
CDatabase * pDatabase = new CDatabase;
TRY
{
pDatabase->OpenEx( _T("DSN=ODBCName;UID=***;PWD=***"), CDatabase::noOdbcDialog);
}
CATCH (CDBException, e)
{
delete pDatabase;
return;
}END_CATCH
SQL.Format("exec sp_Name");//有參數的話直接寫再後面
pDatabase->ExecuteSQL(SQL);
pDatabase->Close();
delete pDatabase;
****************************
below is from MSDN,you can find a lot of technical article in MSDN if you search"stored procere and VC"
good luck
Steps To Reproce Behavior
In the SQL Server 7.0 Query Analyzer select the test database Pubs.
Create the following stored procere. This stored procere returns a recordset and an out parameter count.
if exists (select * from sysobjects where id = object_id(N'[dbo].[GetJobs]') and OBJECTPROPERTY(id, N'IsProcere') = 1)
drop proc GetJobs
go
create proc GetJobs @id as int, @count as int [out] as
begin
Select @count = Count(*) from jobs where job_id >@id
Select * from jobs where job_id >@id
end
go
Use VC App Wizard to create a new console application and modify the code as follows:
#include "stdafx.h"
#include "stdio.h"
#import "C:\PROGRA~1\COMMON~1\System\ado\msado15.dll" no_namespace rename ("EOF", "EOF2")
struct InitOle {
InitOle() { ::CoInitialize(NULL); }
~InitOle() { ::CoUninitialize(); }
} _init_InitOle_;
int main(int argc, char* argv[])
{
_variant_t varErr((long)0, VT_ERROR);
_CommandPtr comm(__uuidof(Command));
_ConnectionPtr conn(__uuidof(Connection));
_bstr_t connstr="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=(local)";
conn->Open(connstr, "", "", adConnectUnspecified);
comm->ActiveConnection=conn;
comm->CommandText="GetJobs";
comm->CommandType = adCmdStoredProc ;
comm->Parameters->Refresh();
_variant_t recs;
comm->Parameters->Item[_variant_t((short)1)]->Value= _variant_t((long)5);
_RecordsetPtr rs = comm->Execute(&recs, &vtMissing,adCmdStoredProc);
_variant_t recordcount= comm->Parameters->Item[_variant_t((short)2)]->Value;
printf("recordcount = %li\n", (long)recordcount);
return 0;
}
Change the Datasource, User ID and password in the connection string above.
The recordcount variant that the above code returns is of type VT_NULL rather than the number of records that the stored procere returns.
G. c程序該怎麼樣調用oracle存儲過程並獲取存
如果已經存在一個存儲過程A（參數）；
那麼在存儲過程B中可以直接通過：
values := A(參數);即可實現調用。
備註：values必須在初始化過程中進行定義如： values VARCHAR(30);並且此類型必須與A存儲過程返回參數類型一致。
H. C語言 怎麼 調存儲過程
C語言里沒有存儲過程，只有函數，函數調用有兩種方式
傳值調用(call by value)和傳址調用(call by reference)
例如
f1(x)
{
int a;
a=3*1-1；
f2(x,a);
return a+x;
}
f2(int r,int s)
{
int y;
y=2*r+1;
s=x*r;
r=s-y;
return;
}
f1中調用了f2函數，若第一個參數採用傳值方式（無返回值，即f1中x=3 不變，只是把值傳給f2使用而已）第二個參數採用傳址方式（返回的是s的地址引用,即f1中a的值與f2中s的值相等）若x=3,則a+x=24
I. 關於存儲過程創建和C#調用
declare
@insertId
intBEGIN
TRY
BEGIN
TRAN
--准備事務
intsert
into
a(f1,f2)values
('111','2222')
set
@InsertId=(select
@@IDENTITY)
insert
into
b(f1,f2)values(@InsertId,'3333') COMMIT
TRAN
end
TRY
BEGIN
catch
ROLLBACK--
回滾事務
END
CATCH -----我用的是mssql2008的，估計05的也能運行以上代碼，2000的估計就不行了
J. C#中使用存儲過程、觸發器、範式！
use
OlayOnlineShop
go
--
=============================================
--
創建觸發器
當管理員刪除某個產品時先把購物車對應的產品清空
--
=============================================
IF
EXISTS
(SELECT
name
FROM
sysobjects
WHERE
name
=
'trig_ProctInfo')
DROP
TRIGGER
trig_ProctInfo
GO
CREATE
TRIGGER
trig_ProctInfo
ON
ProctInfo
INSTEAD
OF
DELETE
AS
BEGIN
--產品ID
DECLARE
@ProctId
INT
SELECT
@ProctId=ProctId
FROM
DELETED
--判斷購物車中是否有該產品
IF
EXISTS
(SELECT
CartId
FROM
Cart
WHERE
ProctId=@ProctId)
BEGIN
DELETE
FROM
Cart
WHERE
ProctId=@ProctId
END
DELETE
FROM
ProctInfo
WHERE
ProctId=@ProctId
END
GO
--
=============================================
--
創建觸發器
當刪除購物車時先清空對應的定單信息
--
=============================================
IF
EXISTS
(SELECT
name
FROM
sysobjects
WHERE
name
=
'trig_Cart')
DROP
TRIGGER
trig_Cart
GO
CREATE
TRIGGER
trig_Cart
ON
Cart
INSTEAD
OF
DELETE
AS
BEGIN
--購物車ID，訂單ID
DECLARE
@UserId
INT,
@CartId
INT,@OrderId
INT
--提取
用戶ID，購物車ID和訂單ID
SELECT
@UserId=UserId
FROM
DELETED
DECLARE
cart_cursor
CURSOR
SCROLL
DYNAMIC
FOR
--查詢數據
存入游標
SELECT
CartId
FROM
Cart
WHERE
UserId=@UserId
OPEN
cart_cursor
FETCH
NEXT
FROM
cart_cursor
INTO
@CartId
--循環刪除訂單和購物車
WHILE(@@fetch_status=0)
BEGIN
IF
EXISTS
(SELECT
OrderId
FROM
OrderInfo
WHERE
CartId=@CartId)
BEGIN
SELECT
@OrderId=OrderId
FROM
OrderInfo
WHERE
CartId=@CartId
DELETE
FROM
OrderInfo
WHERE
OrderId=@OrderId
END
FETCH
NEXT
FROM
cart_cursor
INTO
@CartId
END
DELETE
FROM
Cart
WHERE
UserId=@UserId
CLOSE
cart_cursor
DEALLOCATE
cart_cursor
END
GO
---
=============================================
--
創建出發器
當用戶下了訂單,給用戶加消費積分
--
==============================================
IF
EXISTS
(SELECT
name
FROM
sysobjects
WHERE
name
='trig_OrderInfo'
)
DROP
TRIGGER
trig_OrderInfo
GO
CREATE
TRIGGER
trig_OrderInfo
ON
OrderInfo
FOR
INSERT
AS
BEGIN
--定義購物車ID,用戶ID,產品ID
以及產品價格和積分值
DECLARE
@cardId
INT,@userId
INT,@proctID
INT,@price
MONEY,@cent
INT
--獲取購物車ID和,用戶ID,產品ID以及產品價格
SELECT
@cardId
=
CartId
FROM
INSERTED
SELECT
@userId
=
UserId
FROM
Cart
WHERE
CartId=@cardId
SELECT
@proctID
=ProctId
FROM
Cart
WHERE
CartId=@cardId
SELECT
@price=ProctPrice
FROM
ProctInfo
WHERE
ProctId=@proctId
SET
@cent=@price/50
---獲取積分,以50為等級
IF(@cent<1)
RETURN
ELSE
BEGIN
UPDATE
UserInfo
SET
Mark=Mark+@cent
WHERE
UserId=@userId
END
END
GO
--
=============================================
--
創建觸發器
當同一用戶購買同一商品時數量增加
--
=============================================
IF
EXISTS
(SELECT
name
FROM
sysobjects
WHERE
name
=
'trig_Cart'
)
DROP
TRIGGER
trig_Cart
GO
CREATE
TRIGGER
trig_Cart
ON
Cart
INSTEAD
OF
INSERT
AS
BEGIN
DECLARE
@userId
INT,@proctId
INT,@count
INT
DECLARE
@Date
DATETIME,@Remark
VARCHAR(200),@Remark2
VARCHAR(200)
--取出用戶ID和產品ID等
SELECT
@userId=UserId
,@proctId=ProctId,@count=[Count],
@Date=[Date],@Remark=Remark,@Remark2=Remark2
FROM
INSERTED
--判斷用戶是否購買過產品
IF
EXISTS(SELECT
UserId
FROM
Cart
WHERE
UserId=@userId)
BEGIN
--判斷用戶購買的產品是否跟上次一致
IF
EXISTS(SELECT
ProctId
FROM
Cart
WHERE
ProctId=@proctId)
BEGIN
--取出同一產品的數量
UPDATE
Cart
SET
[Count]=[Count]+@count
WHERE
UserId=@UserId
AND
ProctId=@proctId
END
ELSE
BEGIN
--用戶購買的產品不一致
INSERT
INTO
Cart
Values(@userId,@proctId,@count,@Date,@Remark,@Remark2)
END
END
ELSE
BEGIN
--用戶沒有購買過產品
INSERT
INTO
Cart
Values(@userId,@proctId,@count,@Date,@Remark,@Remark2)
END
END
GO
------用戶信息表UserInfo測試數據存儲過程
:
proc_userInfo_all
USE
OlayOnlineShop
IF
EXISTS
(SELECT
name
FROM
sysobjects
WHERE
name
=
'proc_userInfo_all')
DROP
PROCEDURE
proc_userInfo_all
GO
CREATE
PROCEDURE
proc_userInfo_all
@LoginName
VARCHAR(20),@UserName
VARCHAR(20),
@Password
NVARCHAR(50),@Gender
BIT,@Age
INT,@Email
VARCHAR(50),
@Address
VARCHAR(500),
@Date
DATETIME,@Role
INT,@Mark
INT,@Remark
VARCHAR(200)
AS
INSERT
INTO
UserInfo
(LoginName,UserName,[Password],Gender,Age,Email,Address,[Date],Role,Mark,Remark)
VALUES
(@LoginName
,@UserName
,@Password
,@Gender,
@Age,@Email,@Address
,@Date
,@Role
,@Mark,@Remark
)
GO
--
EXEC
proc_userInfo_all
'KK','瀟瀟','999999',1,18,'[email protected]','廣西南寧','2007-9-19',1,999,''
-----產品類別信息表Category測試數據存儲過程
:
pro_Category_all
IF
EXISTS
(SELECT
name
FROM
sysobjects
WHERE
name
=
'proc_Category_all')
DROP
PROCEDURE
proc_Category_all
GO
CREATE
PROCEDURE
proc_Category_all
@CategoryName
VARCHAR(50),@Description
VARCHAR(500),
@Remark
VARCHAR(200)
AS
INSERT
INTO
Category
(CategoryName,[Description],Remark)
VALUES(@CategoryName,@Description,@Remark)
GO
--EXEC
proc_Category_all
'保養類','能保養皮膚等等....','很棒的哦!!!!'
---產品信息表ProctInfo測試數據存儲過程
:
pro_ProctInfo_all
IF
EXISTS
(SELECT
name
FROM
sysobjects
WHERE
name
=
'proc_ProctInfo_all')
DROP
PROCEDURE
proc_ProctInfo_all
GO
CREATE
PROCEDURE
proc_ProctInfo_all
@ProctName
VARCHAR(200),@CategoryId
INT,
@ProctBigPicture
VARCHAR(200),@ProctSmallPicture
VARCHAR(200),
@ProctPrice
MONEY,@Description
VARCHAR(200),@Virtue
VARCHAR(1500),
@Element
VARCHAR(1500),@HowToUse
VARCHAR(1500),@Date
DATETIME,@Remark
VARCHAR(200)
AS
INSERT
INTO
ProctInfo
(ProctName,CategoryId,ProctBigPicture,ProctSmallPicture,ProctPrice,[Description],
Virtue,Element,HowToUse,[Date],Remark)
VALUES
(@ProctName,@CategoryId,@ProctBigPicture,@ProctSmallPicture,@ProctPrice,@Description,
@Virtue,@Element,@HowToUse,@Date,@Remark)
GO
--
EXEC
proc_ProctInfo_all
'防曬油',1,'f.jpg','b.jpg',80.00,'女士專用','保護女士外出遊玩','使用方法很簡單','產品成分','2007-10-29','備注'
----購物車信息表Cart測試數據存儲過程
:pro_Cart_all
IF
EXISTS
(SELECT
name
FROM
sysobjects
WHERE
name
=
'proc_Cart_all')
DROP
PROCEDURE
proc_Cart_all
GO
CREATE
PROCEDURE
proc_Cart_all
@UserId
INT,@ProctId
INT,
@Date
DATETIME,@Count
INT,
@Remark
VARCHAR(200)
AS
INSERT
INTO
Cart(UserId,ProctId,[Date],Count,Remark)
VALUES(@UserId,@ProctId,@Date,
@Count,@Remark)
GO
--EXEC
proc_Cart_all
1,1,'2007-10-29',1,'購物車'
---定單信息表OrderInfo
測試數據存儲過程:pro_OrderInfo_all
IF
EXISTS
(SELECT
name
FROM
sysobjects
WHERE
name
=
'proc_OrderInfo_all')
DROP
PROCEDURE
proc_OrderInfo_all
GO
CREATE
PROCEDURE
proc_OrderInfo_all
@CartId
INT,@Date
DATETIME,@Postalcode
CHAR(6),
@BillerAddress
VARCHAR(500),@BillerName
VARCHAR(20),
@Phone
VARCHAR(20),@Remark
VARCHAR(200)
AS
INSERT
INTO
OrderInfo
(CartId,[Date],Postalcode,BillerAddress,BillerName,Phone,Remark)
VALUES(@CartId,@Date,@Postalcode,@BillerAddress,@BillerName,@Phone,@Remark)
GO
--EXEC
proc_OrderInfo_all
1,'2007-10-29','534000','南寧東葛路66號','95599
8153
95063
52662','2024188','定單'
---留言信息表MessageBoard測試數據存儲過程
:
pro_MessageBoard_all
IF
EXISTS
(SELECT
name
FROM
sysobjects
WHERE
name
=
'proc_MessageBoard_all')
DROP
PROCEDURE
proc_MessageBoard_all
GO
CREATE
PROCEDURE
proc_MessageBoard_all
@UserId
INT,@Topic
VARCHAR(200),@Content
VARCHAR(200),
@Date
DATETIME,@Remark
VARCHAR(200)
AS
INSERT
INTO
MessageBoard
(UserId,Topic,Content,[Date],Remark)
VALUES(@UserId,@Topic,@Content,@Date,@Remark)
GO
--EXEC
proc_MessageBoard_all
1,'2007-10-29','我想購買防曬油','2007-10-29','留言'
---搜索產品信息
IF
EXISTS
(SELECT
name
FROM
sysobjects
WHERE
name
=
'proc_ProctInfo')
DROP
PROCEDURE
proc_ProctInfo
GO
CREATE
PROCEDURE
proc_ProctInfo
@CategoryName
VARCHAR(50),@ProctName
VARCHAR(200),
@MinMoney
VARCHAR(100),@MaxMoney
VARCHAR(100)
AS
DECLARE
@sql
VARCHAR(800)
DECLARE
@min
VARCHAR(100)
DECLARE
@max
VARCHAR(300)
SET
@min='0'
SET
@max='100'
SELECT
@sql='select
C.CategoryId,C.CategoryName,P.ProctId,P.ProctName,P.ProctSmallPicture,P.ProctPrice
from
ProctInfo
P
inner
join
Category
C
on
P.CategoryId=C.CategoryId'
--判斷產品類別是否為空
IF
(@CategoryName
<>
''
AND
@CategoryName
is
not
null)
BEGIN
--判斷是否搜索全部產品
IF
(@CategoryName!='全部')
BEGIN
SELECT
@sql
=
@sql+'
where
C.CategoryName
like
''%'
+
@CategoryName
+
'%'''
END
END
--判斷產品名稱是否存在
IF
(@ProctName
<>
''
AND
@ProctName
is
not
null)
BEGIN
--判斷是否搜索全部產品
IF
(@CategoryName='全部')
BEGIN
SELECT
@sql
=
@sql+'
where
P.ProctName
like
''%'
+
@ProctName
+
'%'''
END
ELSE
BEGIN
SELECT
@sql
=
@sql+'
and
P.ProctName
like
''%'
+
@ProctName
+
'%'''
END
END
--判斷小金額是否有
IF
(@MinMoney
!=
'')
BEGIN
SET
@min
=
@MinMoney
END
--判斷大金額是否有
IF
(@MaxMoney
!=
'')
BEGIN
SET
@max
=@MaxMoney
END
IF
(@MinMoney
!=
''
OR
@MaxMoney
!=
'')
BEGIN
SELECT
@sql
=
@sql+'
and
P.ProctPrice
between
'+@min+'
and
'+@max
END
EXEC(@sql)
GO
EXEC
proc_ProctInfo
'新生','玉蘭','0','28'