Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 31 Mar 2005 @ 13:39:44 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Problem in compiling Stored procedure
 
From:   Fred W Pluebell

This is a documented but frequently overlooked restriction. A quick check of the Messages manual for SPL1078 reveals:

Explanation: The reason is that the creator and the immediate owner of the stored procedure is not the same. Hence the specified DDL, DCL, or dynamic SQL statement cannot be specified in the SPL source text.

The term "creator" means the username issuing the CREATE PROCEDURE, and "immediate owner" means the database/user in which the stored procedure is actually being created. In other words, if you are logged on as USER1 you must create the stored procedure as USER1.some_name, not SomeOtherDB.some_name.



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023