Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI-1246 The Logical Schema has not been set for (Procedure Name)

William KerrMar 28 2016 — edited Mar 28 2016

Hi All,

Quick background I am attempting to write a procedure to read from CSV and insert attributes into a Name Object.

Opening new thread, different issue I have run into.

I have recently tried to create a procedure for an ODI project (version ODI12c) when I try to run the procedure I get the following error code 'ODI-1246 The Logical Schema has not been set for (Procedure Name)'

I have created a physical and logical schema for my database ('OO') under the Oracle technology using 'OO' as the schema and wrep (User with WORKREP1) as the work schema.

I am using the JDBC URL 'jdbc:oracle:thin:@localhost:1521:xe' and have tested the connection to the database successfully.

I don't think I should need to create a logical schema for a procedure, although I might be wrong.

Any help will be most appreciated.

Regards,

William

This post has been answered by ASP_007 on Mar 28 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 25 2016

Added on Mar 28 2016

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration

9 comments

5,016 views