Biztalk issue

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Biztalk issue

Viewing 1 reply thread
  • Author
    Posts
    • January 22, 2008 at 6:02 PM #18813
      community-content

        Hi,
        I am trying to retrieve data from oracle table using BizTalk oracle adapter. I have the quary in package. I have to use package for this project.

        I could not create Oracle schema from “add Generate Items” wizard using package. When i run the “add generate items” for the package, using the receive port that connect to the db, it is creating object schema and orchestration only, not procedure schema.

        How can I use procedure(package) to retrieve data from Oracle database in biztalk 2006 R 2?
        —
        Thank you,

        Siva

      • January 23, 2008 at 7:41 AM #18819
        community-content

          Hi Siva,
          how did you manage to create the package because when try to I get this error:

          I-OAP0022: Unable to find object describing this table: OracleDb://ALASIS/EPMINT/Procedures/GRANT_PACKAG

          When I created an oracle schema i used the Native Sql option, sorry.

          Grant Lindsay

          • January 23, 2008 at 8:24 PM #18822
            community-content

              Did package compile with out issue? could you post the package here? its look like package has some issue. what is ur parameter for procedure?

              • January 24, 2008 at 2:15 AM #18825
                community-content

                  Hi Silva,
                  package complied without errors, here is the package:

                  CREATE OR REPLACE package grant_package AS

                  PROCEDURE test_return (out_text IN OUT VARCHAR2);

                  end grant_package;
                  /

                  CREATE OR REPLACE package body grant_package AS

                  PROCEDURE test_return (out_text IN OUT VARCHAR2) IS

                  v_text varchar2(100):=’Hello Grant’;

                  Begin

                  out_text:=v_text;

                  END test_return;

                  end grant_package;
                  /

                  Thanks for your helps

                  Grant Lindsay

                  • January 24, 2008 at 6:17 AM #18830
                    community-content

                      Hi,

                      I could create schema with out error. Could you check ur send/receive port? could u check the connection? where is ur package located?

                      I put the package under my schema. I created a send port using my user id and pwed. when i run add genearate items, i use the send port i created as port option. then i selected the package under my schema. I think ur package not saved under Nativesql. i think it is under ur schema.

                      could u double check it?

                      • January 24, 2008 at 7:05 AM #18831
                        community-content

                          Hi Silva,
                          I am trying to call the package from the receive port, the package is displayed under my schema name > Procedures and I can see “Grant_Package” but I get the error as stated at the start “I-OAP0022: Unable to find object describing this table:” I can use the native and do a select on the table so I know there is not problems connecting to the database.

                          I am not using any post or poll sql in the adapter should I be?

                          Thanks for your help

                          Grant Lindsay

                          • January 24, 2008 at 7:59 AM #18832
                            community-content

                              Could you send me the project if it is ok with you? If you are sending, please send  me all the infomation about your receive port set up, so i can set smiller on my side and test it here.

                              Its looks like fine from my side..Let me test with your project.

                              Siva

                • Author
                  Posts
                Viewing 1 reply thread
                • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.