Re: [GENERAL] Using a function in different schemas

2011-08-31 Thread Juan Manuel Alvarez
Thanks Adrian! That is exactly what I was looking for! =o) On Wed, Aug 31, 2011 at 3:35 PM, Adrian Klaver wrote: > On 08/31/2011 08:38 AM, Juan Manuel Alvarez wrote: >> >> Hello everyone! This is the first time I post on this list. Until now, >> I was able to get a solution to all the problems I

Re: [GENERAL] Using a function in different schemas

2011-08-31 Thread Adrian Klaver
On 08/31/2011 08:38 AM, Juan Manuel Alvarez wrote: Hello everyone! This is the first time I post on this list. Until now, I was able to get a solution to all the problems I had, but now I am facing an issue I can't resolve, so I hope you can help me. The problem goes like this: I am using the sa

[GENERAL] Using a function in different schemas

2011-08-31 Thread Juan Manuel Alvarez
Hello everyone! This is the first time I post on this list. Until now, I was able to get a solution to all the problems I had, but now I am facing an issue I can't resolve, so I hope you can help me. The problem goes like this: I am using the same distribution of tables/functions into different sc

Re: [GENERAL] using a function

2010-01-06 Thread Andy Colson
On 1/6/2010 2:45 AM, Filip RembiaƂkowski wrote: 2010/1/5 Andy Colson mailto:a...@camavision.com>> I have a function that's working for what I needed it to do, but now I need to call it for every id in a different table... and I'm not sure what the syntax should be. Here is an ex

Re: [GENERAL] using a function

2010-01-06 Thread Filip RembiaƂkowski
2010/1/5 Andy Colson > I have a function that's working for what I needed it to do, but now I need > to call it for every id in a different table... and I'm not sure what the > syntax should be. > > Here is an example: > > create or replace function test(uid integer, out vhrs integer, out phrs >

[GENERAL] using a function

2010-01-05 Thread Andy Colson
I have a function that's working for what I needed it to do, but now I need to call it for every id in a different table... and I'm not sure what the syntax should be. Here is an example: create or replace function test(uid integer, out vhrs integer, out phrs integer, out fhrs integer) retur

[GENERAL] using a function

2010-01-05 Thread Andy Colson
(*Sorry if this posts twice, I sent it from the wrong account the first time*) I have a function that's working for what I needed it to do, but now I need to call it for every id in a different table... and I'm not sure what the syntax should be. Here is an example: create or replace functi