Questions tagged [procedures]
262 questions
1
vote
1 answer
Why does passing fields between Oracle procedures lose the sizes?
Here's a simple proc which defines 2 numeric fields, 1 as a Number, the other as Decimal, yet when I pass both to another procedures the decimal field is rounded to 0 dp, ie
IAMOUNT ends up with 9875.4321 but IUNITS ends up with 123
CREATE OR…
mgjackson
- 13
- 3
1
vote
2 answers
Calculating running time for C functions
I am working on a server program written in C written as a procedural (not OO) code. Every method implements some specific functionality.
For the diagnostics purpose I want to add code to a bunch of methods that will calculate and print the running…
punekr12
- 653
- 2
- 7
- 14
1
vote
2 answers
Sequential procedures inside DoWork BackgroundWorker
I'm looking to run sequential sub procedures in a background thread. and am wondering if it is permissible to do such by creating a background worker and then calling each procedure separately like so...
Private Sub BGW_DoWork(ByVal sender As…
Uriel Katz
- 319
- 1
- 8
- 21
1
vote
2 answers
Drop temporary tables in a single session
How to drop the temporary tables in procedures for the same session.
Because I am facing a problem regarding temporary tables in Postgres Sql. If two procedures:
A() having a temporary table say temp(id, name)
B() having a temporary table say…
ripunj2408813
- 33
- 1
- 9
1
vote
2 answers
'Equivalence' in Fortran
I understand that two variables, say a1 and a2 appear in Equivalence(a1,a2) statement in Fortran, then they occupy the same memory space. So say this happens in a procedure where both a1 and a2 are local variables in that procedure.
This means that…
Awoken
- 79
- 6
1
vote
1 answer
variables/arrays from tcl procedure
How could i pass some variables/ arrays outside of procedure?
Lets say I've my procedure 'myproc' with inputparameters {a b c d e}, e.g.
myproc {a b c d e} {
... do something
(calculate arrays, lists and new variables)
}
Inside this…
David K.
- 123
- 5
1
vote
2 answers
PL/SQL Statements ignored & Not enough values
--Below is for testing only - to be deleted later
CREATE OR REPLACE PROCEDURE movie_rental_sp
(movieIdCount IN OUT NUMBER,
movieID IN OUT NUMBER)
IS
noMovie EXCEPTION;
BEGIN
SELECT MOVIE_ID, count(movie_id)
INTO movieIdCount
FROM…
Josh Lee
- 11
- 2
1
vote
3 answers
copying stored procedures each into its own file using ant
I want to be able to have an ant task which would connect to a remote oracle instance and copy the stored procedures each into its own file. I know I can have an ant sql task which will do
SELECT object_type,
object_name,
…
user188662
- 21
- 3
1
vote
0 answers
Parameter without datatype in Mysql Procedure?
Ok, so while writing a Stored Procedure in MYSQL i came across a problem where i had to write a procedure where i had to pass a parameter whose data type could depend upon the other parameter. I mean let us say that the first parameter is an a…
anurag
- 35
- 3
1
vote
3 answers
More intuitive way of using a variable as a default value for a TCL procedure
So, I used the thread of a similar name to get this working using the list command. Here is my working code:
proc E364xA::Connect [list [list VisaAlias ${E364xA::DefaultAlias}]] {
::VISA::Connect $VisaAlias
}
Now this is working currently by…
jjno91
- 653
- 7
- 19
1
vote
2 answers
MySQL calling a procedure with select statements from a trigger - "Not allowed to return a result set from a trigger"
Here's one for the SQL wizards. Similar questions have been asked before and I have some idea what the problem is but I'm having trouble rewriting the select statements inside my procedure to avoid returning a result set, and returning the global…
111
- 1,788
- 1
- 23
- 38
1
vote
3 answers
Basics of defining procedures in Python?
Hey Guys I am pretty new to Python and I am learning this programming language. I am using the Python IDE (GUI) for running all my codes. I have covered till the topic of defining custom procedures. However upon execution it is not giving any…
Rahul Ghosh
- 21
- 1
- 1
- 5
1
vote
1 answer
How to selectively export oracle to dump - minus some procedures or packages
We need to export an 11g database to get it into an 10g system. But we need to leave out a package, or at least some functions and procedures, that were accidentally implemented using 11g-only features.
Thankfully, the 10g is just a reporting…
JohnZastrow
- 449
- 1
- 5
- 12
1
vote
1 answer
how to add annonymus block to procedure Oracle?
How I can create procedure with following code because I'm new in oracle always used sybase/ms sql and it was easier.
DECLARE
temp VARCHAR2 (255);
last_val NUMBER(9, 0);
CURSOR c1 IS
SELECT DISTINCT table_name
FROM …
Endiss
- 699
- 2
- 10
- 23
1
vote
2 answers
return statement returns None instead of value
I have run into a weird problem. This code returns None instead of True, even though it goes in to the correct branch and evaluates to True:
edges = { (1, 'a') : [2, 3],
(2, 'a') : [2],
(3, 'b') : [4, 3],
(4, 'c') : [5]…
fixxxer
- 15,568
- 15
- 58
- 76