Syntax error?

gbrown
gbrown Member
in Workbench

Hello,

I am trying to load a Oracle discover report into DOMO. The select statement works fine but when I add the statement below before the select statement I get a syntax error. Does anyone see a problem that needs to be changed?

execute fnd_client_info.set_org_context (209);

image.png

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    You added single quotes in the image. In Oracle, when you're calling a procedure like fnd_client_info.set_org_context, you should pass numeric values without quotes, as it expects a number rather than a string.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    You added single quotes in the image. In Oracle, when you're calling a procedure like fnd_client_info.set_org_context, you should pass numeric values without quotes, as it expects a number rather than a string.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories