Archives of the TeradataForum
Message Posted: Tue, 12 Feb 2008 @ 22:00:04 GMT
> Code = 3822. > 3822: Cannot resolve column 'SEL CURRENT_DATE'. Specify table or view. > Output directed to Answer set window.
I'm not sure why you would get that specific error, but you can't run that query like that. I strongly recommend you refer to the SP Manual (and others). Here is an extract from the SP manual:
Dynamic SQL Statements That Cannot Be Used In Stored Procedures The following statements cannot be used as dynamic SQL in stored procedures:
* ALTER PROCEDURE ... * SELECT * SELECT ... INTO ... * SHOW
If you want to get the results of something use a cursor or a select into. If you need to get the results of some dynamic sql then insert into an intermediate table and retrieve the results via a cursor.
I might be going out on a limb here (because I don't know what you are trying to achieve), but you should also seriously consider whether you are going down the right path. I'm not that knowledgeable about Oracle, but I do know they tend to use SP's to process stuff. Teradata is most powerful when you process data in sets (i.e. via SQL - not cursors and SP's). You will not see the same level of performance with SP's processing data one row at a time compared to the performance of processing data in sets.
I hope this helps
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|