Re: embedded function in Oracle database

In article <6gce5h$eol$1_at_infosite.cs.hku.hk>,   kwtse_at_cs.hku.hk (Tse Ka Wai (CS)) wrote:
>
>
> i am currently doing a project on using PowerBuilder as the front end at
> the NT and Oracle at the UNIX as the back end.
>
> i would like to know if there is any means for me to put a function in the
> back end side such that this function can filter data retrieved from the
> PowerBuilder.
>
> e.g. i have stored some integers in a table in Oracle which are
> encrypted and when the PowerBuilder retrieves these integers, they will be
> decrypted and be stored in a data window in their real values. my function
> is to decrypt those integers, not decrypting it in the database table but
> the value in PowerBuilder. i do not want the function be in the
> PowerBuilder as i do not want to add much code in PB.
>
> thanks in advance.
>
> good luck.
>
> tse ka wai CS3 --> ?
>

I support you should create a stored procedure in PL/SQL. I think you should put it in a package.
In the package specification you must put this line: \n pragma restrict_references(funct_name, WNDS,WNPS) after the function definition.
the in your select statement you can reference your function. e.g. select convert(num1), convert(num2) from table1 where convert(num2) = 'something' and so on.

I don't know much about powerbuilder you might need to create a view if you cannot write the select statement yourself.

Hope this will work.

mdaskalo

[Quoted] -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 07 1998 - 00:00:00 CEST