Re: ora2pg error : DBD::Oracle::db prepare failed: ORA-28110

On 6/11/20 12:32 PM, George Dimopoulos wrote:
> Hi Everyone,
> 
> I am new to migrating oracle 18c EX to postgres.
> 
> I do not know if this site is the correct site for my problem. If it is 
> not, can you please point me to correct site to ask the question?
> 
> I used ora2pg to start the migration but when I try to run “ ora2pg -t 
> SHOW_REPORT” I get the following error:
> 
> /DBD::Oracle::db prepare failed: ORA-28110: policy function or package 
> NRM_CAVES.UTIL_SECURITY has error (DBD ERROR: error possibly near <*> 
> indicator at char 49 in 'SELECT DISTINCT c.SHAPE.SDO_GTYPE FROM 
> NRM_CAVES.<*>LOCATIONS c WHERE ROWNUM < 50000') [for Statement "SELECT 
> DISTINCT c.SHAPE.SDO_GTYPE FROM NRM_CAVES.LOCATIONS c WHERE ROWNUM < 
> 50000"] at C:/Strawberry/perl/site/lib/Ora2Pg.pm line 9408/.

So does:

SELECT DISTINCT c.SHAPE.SDO_GTYPE FROM NRM_CAVES.LOCATIONS c WHERE 
ROWNUM < 50000

run correctly in the database?

> 
> I have set COMPILE_SCHEMA     0
> 
> This error appears on every time no matter what I set TYPE, even I have 
> excluded all the tables where this policy applies.
> 
> Please help,
> 
> Best Regards,
> 
> George
> 
> George Dimopoulos
> 
> Oracle DBA and Weblogic  Admin
> 
> TechTrend Inc.
> 
> 8270 Willow Oaks Corporate Drive, Suite 625, Fairfax, VA 22031
> 
> Office: 703-521-9392 | Fax 703-663-8668
> 
> gdimopoulos@techtrend.us <mailto:gdimopoulos@techtrend.us>| 
> www.techtrend.us <http://www.techtrend.us/>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com