Creating a REST API with oracledb
I created the controller for a database that I am currently using with tables DH_STAFF, DH_BRANCH and DH_CLIENT. Not sure why but I keep getting ORA-00933 every time I try to query a select or execute some procedure. What's the issue?
14 Replies
⌛ This post has been reserved for your question.
Hey @verbose! Please useTIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here./closeor theClose Postbutton above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.
Unknown User•13mo ago
Message Not Public
Sign In & Join Server To View
most SQL queries are really simple
apologies for not providing an example lemme do that rn
basically a simple select stagement that uses a bind pattern to find the STAFFNO and get that row
Unknown User•13mo ago
Message Not Public
Sign In & Join Server To View
sounds good lemme try it
@groot0003
are you a genius?
how was it just a
;
:hidethepain:Unknown User•13mo ago
Message Not Public
Sign In & Join Server To View
Idk what magic you did but thanks alot!
If you are finished with your post, please close it.
If you are not, please ignore this message.
Note that you will not be able to send further messages here after this post have been closed but you will be able to create new posts.
have you worked with this before??
anyway thanks again Groot, saved me hours 😅
Post Closed
This post has been closed by <@400463761011507212>.