Skip to content
Advertisement

Missing IN or OUT parameter in Oracle SQL

Im getting an error on this parte of SQL{ “U” = UPPER(:codigo) }. When i remove the variable and hardcode :codigo as u or U it works fine. The erro i receive is Missing In or Out parameter. I’m receiving this error on Oracle 12c Service Bus

Full SQL:

Advertisement

Answer

The problem was:
Each time variable :posicao was referenced my request need to have the same exact number of variables

let $dbInput := posicao1, posicao2

Even if posicao1 and posicao2 got the same values.
Oracle Service Bus works like this when calling DbAdapters

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement