topic Calling a SQL Stored Procedure in Developers

Calling a SQL Stored Procedure

paulsparrow — Tue, 26 Jan 2010 20:42:32 GMT

I am having trouble with the code below. Similar code has worked before and I don't get errors but it doesn't seem to run the stored procedure.

Because I don't have rights to run a stored procedure under the schema dbo. I have created one under my own schema nscu\pauspar which I believe is where the problem is.

It connects, changes to temptables database.

PROC SQL;
CONNECT TO ODBC(dsn=nscu070t
);
EXECUTE (use temptables
exec sp_load_contact_history_bird
)
BY ODBC ;
DISCONNECT FROM ODBC ;
QUIT;
RUN;

Re: Calling a SQL Stored Procedure

Vince_SAS — Tue, 26 Jan 2010 21:04:26 GMT

The focus of this forum is SAS Stored Processes

http://support.sas.com/documentation/cdl/en/stpug/61271/HTML/default/a003152554.htm

Someone here may be able to provide you with an answer, but if not, you can try opening a track with our Technical Support department:

http://support.sas.com/ctx/supportform/createForm

Vince DelGobbo
SAS R&D

Re: Calling a SQL Stored Procedure

LinusH — Wed, 27 Jan 2010 14:54:58 GMT

Don't really follow you about what you think is the problem.
Can you run this stored procedure with same schema from some other interface to your database (which is...?).
If it has something to do with user rights, I suggest that you start by talking to some DBA that manages this DB.
/Linus