Execute Oracle's stored procedures from tpt

Tools
py
Enthusiast

Execute Oracle's stored procedures from tpt

Hi everyone,

I found a subject where I see it is not possible to delete from tpt on Oracle, but I was wondering if :

it's possible to launch Oracle's stored procedures from tpt ?

Or doing updates on Oracle's tables from tpt ?

Thanks,

py

6 REPLIES
Junior Supporter

Re: Execute Oracle's stored procedures from tpt

Hi.

>>"Is it possible to launch Oracle's stored procedures from tpt? Or doing updates on Oracle's tables from tpt ?"

The short answer: NO.

The long answer: YES.

You will need a wrapper function and more...

It is quite long to explain, but the whole story can be found here (in spanish, as usual):

https://carlosal.wordpress.com/2016/04/06/ejecutando-dmls-y-stored-procedures-en-oracle-con-tpt/

HTH.

Cheers.

Carlos.

py
Enthusiast

Re: Execute Oracle's stored procedures from tpt

Thanks a lot !

Re: Execute Oracle's stored procedures from tpt

Hi All,

I am doing Oracle to Terdata SP migartion , could you please guide me how to do and docs,...

1. how to convert the this Rank() funtion in oracle format to TD format, please help me 

sel *

   from (select z.*,

                     rank() over(partition by z.pnr_id, z.board_point || z.off_point, z.host_segment_number, z.type_of_service, z.departure_date order by z.pnr_id, z.flown_flag_etl desc) as rnk

                from (select *   from EDW_EK_POC.STG_PNR_ITNS x

                      UNION all

              sel *   from EDW_EK_POC.STG_PNR_FLOWN_ITNS y

                        ) Z)

       where rnk = 1 and segment_type in ('0','1','2','3','7','9')   ;

Junior Contributor

Re: Execute Oracle's stored procedures from tpt

The RANK is exactly the same in Teradata, there's just a missing table alias directly before WHERE. 

Oracle allows omitting that alias, but Standard SQL requires it.

Re: Execute Oracle's stored procedures from tpt

Hi Dnoeth,

Thank you so much

Thanks,

KSM

Re: Execute Oracle's stored procedures from tpt

Hi All,

how to convert oracle to teradata this query?

    select distinct p.param_value

      into l_freedom_type4

      from EDW_EK_POC.cdw_parameter_mapping p

     where p.param_name = 'CDW_FREEDOM_TYPE_4';

please advice any one.

Thanks,

KSM