Calling Perl function within ORACLE PL-SQL statement [message #38145] |
Mon, 25 March 2002 07:30 |
Rajesh K
Messages: 8 Registered: March 2002
|
Junior Member |
|
|
Hi all,
Can anyone suggest any ideas to implement the following requirement.
I need to do a pattern search on a column from a ORACLE table. This pattern search needs to work similar to the "amatch()" function available in the String::Approx module in Perl. i.e I need to call such a function from within a PL-SQL SELECT statement.
I am basically looking for giving a search string as the input parameter to this Perl function and this function has to return the values from a column of the ORACLE database table that matches the string. So this would be my output of the select statement.
|
|
|
|