Menu ▾ ▴

#3 dblink.call argument

v1.0 (example)
closed-fixed
Takashi Ohnishi
dblink_plus (5)
5
2014-05-21
2011-09-14
kwmkenji
No

If we specify the function call in the argument of dblink.call, OCI error occurs. For example, select * from dblink.call('conn', 'dblink.f_test(ceil(99.1))') as ...

Discussion

  • Sachin Kotwal

    Sachin Kotwal - 2014-05-15

    User want to execute stored procedure dblink.f_test() from Oracle side.
    But oracle standard library function ceil() is passed as argument to dblink.f_test(). This kind of usage is not supported by dblink_plus currently.

    I will write patch for this bug and update.

     

    Last edit: Sachin Kotwal 2014-05-15

  • Takashi Ohnishi

    Takashi Ohnishi - 2014-05-21

    Thanks for reporting, kwmkenji.
    Thanks for fixing, Sachin Kotwal.

    I committed the patch, so I will close this ticket.

     

  • Takashi Ohnishi

    Takashi Ohnishi - 2014-05-21
    • status: open --> closed-fixed
    • assigned_to: Takashi Ohnishi
     
MongoDB Logo MongoDB
Gen AI apps are built with MongoDB Atlas
Atlas offers built-in vector search and global availability across 125+ regions. Start building AI apps faster, all in one place.
Try Free →