Procedure: This procedure works for me. I am executing the procedure with below code: Execution: I have to call the procedure in java with JDBC. So how can I call the procedure in java by above execution code? Answer Use a collection (which you can create using CREATE TYPE … AS TABLE OF …) or VARRAY (like the built-in VARRAYs
Tag: plsql
PL/SQL change value in 1 row in procedure
i do not know where the bug is. I must write the procedure where the 1 specific row will be chaned. Everytime i lunched it, wrote me: Errors: PROCEDURE RENAME_FLYTICKET Line/Col: 1/65 PLS-00103: …
Update Oracle SQL Query in a procedure but throwing missing right parenthesis error
The table sc contains the student id and the course id they attended, followed by it’s corresponding grade. The table course contains the course id and corresponding credits The table student1 contains the student id and corresponding info. In this case I need to calculate the average score of every student and add the rank to table student1 The code
Input parameters in procedure
Tell me how to solve such a case: There is a predicate in the stored procedure that searches for input_param by the input parameter: When calling this procedure, I need to pass two or much parameters: It naturally doesn’t work Are there any solutions? Answer Would this help? Sample data: Procedure:
PLSQL Selecting from table using an array into a variable
I am trying to select some records from a table using an array into the variable init_av_days but its not working out. init_av_days is to be committed to another table after this select query. How best do you suggest i do this? Answer init_av_days is to be committed to another table after this select query Best? Skip PL/SQL entirely, I’d
PL/SQL procedure to output line the given date if not existing, latest date should be given
I have this table informationvalues with the contents: Now I create a procedure where I need to input a date parameter which should output line the correct attr with given price. If the date doesn’t exist the latest date should be selected. The solution table for to_date(’01-jan-19′) would look like this: This would be then output line in the procedure.
Wrong number or types of arguments in call to ‘||’
We are supposed to read a text file, insert that data into a table while taking care of exceptions. This the code for my function: This is how i’ve called the function (but i think it’s wrong): And this is the error I’ve got: I tried to remove the results in the dbms_output and this is what happened: After running
sql query hangs/times out when passed large data
UPDATED: Guys I am passing list of faculty id’s to stored procedure, when i pass more than 10 faculty id’s it’s taking long time to process the data and sometime times out. I spent good amount of time …
Updating salary on employees for each full year they have been working [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question I have to do what i say in the title. I have to update the salary on employees for each full year they have been
APEX: Submit without refreshing the page
I have an interactive report that runs a large query, which takes about 20 seconds to execute. There are many filter items on the APEX page, which affect the data in the report. The report uses a PL/…