IRC log of openacs on 2001-09-03

Timestamps are in UTC.

00:36:02 [loggy]
loggy has joined #openacs
00:36:02 [forward.openprojects.net]
topic is: Welcome to the OpenACS helpline http://openacs.org
00:36:02 [forward.openprojects.net]
Users on #openacs: loggy davb zzzirk chump strainmaker rbm abbaJ AaronSw shagster andyn GEM
00:36:02 [ChanServ]
This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog
00:36:43 [davb]
Good question. I haven't learned in depth yet. Check out the w3c.org pages.
00:37:19 [davb]
http://www.xmlhack.com
00:37:19 [chump]
B: http://www.xmlhack.com from davb
00:37:26 [davb]
B:|XMLhack.com
00:37:26 [chump]
titled item B
00:37:35 [davb]
B: XML news and links to XML resources
00:37:35 [chump]
commented item B
00:51:23 [davb]
brb
00:51:24 [davb]
davb has quit
02:57:19 [gilbertw]
gilbertw has joined #openacs
03:48:52 [davb]
davb has joined #openacs
03:55:17 [gilbertw]
gilbertw has quit
03:55:25 [ChanServ]
ChanServ has changed the topic to: Welcome to the OpenACS Helpline | http://www.openacs.org/
03:55:36 [ChanServ]
This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog
03:55:38 [gilbertw]
gilbertw has joined #openacs
03:55:38 [gilbertw]
gilbertw has left #openacs
04:05:00 [davb]
davb has quit
04:39:50 [gilbertw]
gilbertw has joined #openacs
05:11:14 [gilbertw]
gilbertw has quit
06:44:48 [djg]
djg has joined #openacs
06:58:00 [PascalS]
PascalS has joined #openacs
06:58:09 [PascalS]
mornin!
08:22:23 [til]
til has joined #openacs
09:13:26 [ola]
ola has joined #openacs
09:17:44 [ola]
ola has quit
09:17:48 [ola]
ola has joined #openacs
09:54:37 [til]
til has quit
10:57:10 [til]
til has joined #openacs
11:37:55 [davb]
davb has joined #openacs
11:49:58 [davb]
davb has quit
12:03:29 [til]
a quick oracle q: i want to call a function but i am not interested in the return value (e.g. no variable to put the value in) - what's the syntax for that?
12:22:43 [davb]
davb has joined #openacs
13:02:30 [strainmaker]
why not just "select func() from dual" ?
13:05:01 [til]
that gave me "PLS-00428: an INTO clause is expected in this SELECT statement"
13:05:16 [til]
so i did "select func() into dummy from dual"
13:07:11 [til]
is that the recommended way to do this? its a bit annoying that the dummy variable has to be declared
13:19:16 [davb]
I don't think that's necessary?
13:19:32 [davb]
You are trying to get the value of a function?
13:20:12 [til]
no, i just want to call the function but i am not interested in the return value
13:20:22 [davb]
In Oracle?
13:20:26 [til]
yes
13:20:59 [til]
inside a package, that is
13:21:15 [davb]
Inside a PL/SQL procedure?
13:21:19 [til]
yes
13:21:29 [davb]
I think you can just call it like this func();
13:21:39 [davb]
Maybe you don't need the ;
13:21:46 [davb]
you don't need a select in oracle.
13:21:56 [djg]
afaik that doesnt work in oracle
13:22:03 [djg]
but just ignore the return vale?
13:22:45 [davb]
You are calling a function that returns a value, but you don't need the value?
13:24:41 [davb]
how about v_dummy_variable := function();
13:25:17 [davb]
Here is how to call a procedure that does not return a value:
13:25:18 [davb]
acs_permission.grant_permission(
13:25:18 [davb]
644 | object_id => folder_row.folder_id,
13:25:18 [davb]
645 | grantee_id => static_page.grant_permission.grantee_id,
13:25:18 [davb]
646 | privilege => static_page.grant_permission.privilege
13:25:18 [davb]
647 | );
13:25:25 [davb]
ick.. sorry
13:25:39 [davb]
acs_permission.grant_permission(values);
13:26:28 [til]
but grant_permission is a procedure, not a function i guess?
13:26:53 [til]
when i just called func(); it gave me a "PLS-00221: 'ADD_CONTENT' is not a procedure or is undefined"
13:27:12 [til]
add_content is the name of the function
13:33:52 [til]
til has quit
13:34:13 [til]
til has joined #openacs
13:42:58 [AaronSw]
AaronSw has quit
13:48:45 [davb]
til. you need to call it like this packagename.add_content
13:54:39 [davb]
I have no idea what I am doing, I am just copying from the openacs source.
14:00:07 [til]
i tried it like this but i am getting the compilation error above ... but i have a terrible suspicion - maybe it was all my fault and i did not recreate the package that i am calling (i'll just reinstall and then ask again if still necessary)
14:04:07 [markd]
markd has joined #openacs
14:23:42 [davb]
Hi markd!
14:24:31 [davb]
good luck til
14:25:10 [til]
thanx davb ...
14:38:10 [markd]
hiya
14:38:16 [markd]
what's til up to?
14:40:14 [til]
i was wondering how to call a function from within oracle plsql when i am not interested in the return value (without putting it in a dummy variable)
14:40:55 [til]
doing func(params); returned a compilation error ... but i suspect there's something wrong with my installation so i am reinstalling now
14:42:04 [rbm]
select func() from dual;
14:42:25 [rbm]
you need the "from dual" in Oracle.
14:43:03 [til]
rbm: tried that and oracle said: "PLS-00428: an INTO clause is expected in this SELECT statement"
14:45:44 [markd]
can you write a procedure that calls the function, does the assigning to a variable? and then not do anything with the reply
14:46:15 [markd]
might be easier than trying to contort some sql to drop the return value
14:47:03 [markd]
(and if your'e needing to drop the return value, then it may make sense to re-code the function in question to not return a value)
14:50:13 [til]
ok, i will suggest that to vinod who wrote the acs-mail package with the function that i want to call
14:50:29 [til]
is it possible to overload a function with a procedure in oracle?
14:51:13 [til]
it's only cosmetic though, nothing stops me from doing a select func() into dummy from dual;
14:52:26 [markd]
hmmm.. dunno about the overloading
14:52:29 [markd]
it might work
14:53:34 [ola]
ola has quit
14:55:18 [ola]
ola has joined #openacs
15:00:10 [rbm]
til: oh
15:02:45 [markd]
markd has quit
15:06:16 [markd]
markd has joined #openacs
15:07:21 [til]
til has quit
15:07:39 [til]
til has joined #openacs
15:10:35 [til]
still doesn't work after reinstall. seems a function must be called like "select func() into v_dummy from dual;"
15:32:44 [PascalS]
PascalS has quit
15:43:32 [djg]
y
15:44:12 [rbm]
z
15:44:52 [djg]
hmm tzpical tzpos if zou have to switch kezboards often ;)
15:48:43 [markd]
heh
15:48:54 [matto]
matto has joined #openacs
15:49:03 [matto]
matto has left #openacs
15:49:08 [markd]
SuSE 7.1's installer has a problem - no matter what you choose as the keyboard type during installation, it uses a german layout upon first boot,
16:25:32 [andyn]
andyn has quit
16:32:16 [andyn]
andyn has joined #openacs
16:37:19 [markd]
markd has quit
17:06:11 [Psychephylax]
Psychephylax has joined #openacs
17:06:26 [Psychephylax]
* Psychephylax begins writing his proposal
17:38:04 [markd]
markd has joined #openacs
17:53:37 [markd]
markd is now known as markd2
17:53:42 [markd2]
markd2 is now known as markd
17:53:55 [markd]
markd has quit
17:53:55 [til]
til has quit
18:09:31 [Psychephylax]
Psychephylax has quit
18:19:28 [AaronSw]
AaronSw has joined #openacs
18:24:18 [GEM]
http://allbusiness.findlaw.com/agreements/handspring/softwarelic.html
18:24:19 [chump]
A: http://allbusiness.findlaw.com/agreements/handspring/softwarelic.html from GEM
18:39:02 [markd]
markd has joined #openacs
18:43:24 [strainmaker]
strainmaker has quit
18:46:03 [markd]
markd is now known as d34thl0rD
18:46:27 [d34thl0rD]
* d34thl0rD is L33t
18:46:30 [d34thl0rD]
d34thl0rD is now known as markd
19:16:56 [GEM]
a:Palm OS licensing agreement
19:17:35 [GEM]
A: Palm OS licensing agreement
19:17:36 [chump]
commented item A
19:50:26 [vinod]
vinod has joined #openacs
20:07:50 [markd]
hey Vinod
20:08:20 [vinod]
hey mark! what's new?
20:08:54 [markd]
not much
20:09:02 [markd]
came back from a friend's wedding yesterday
20:09:03 [markd]
down in Virginia
20:10:05 [vinod]
cool! where in VA?
20:10:11 [markd]
Fairfax
20:10:42 [markd]
drove down saturday morning, headed back sunday
20:10:45 [vinod]
nice. one of my best friends lives there. i just visited him a month ago
20:10:52 [vinod]
how long of a drive is that?
20:11:33 [markd]
cool
20:11:39 [markd]
about 4 1/2 hours
20:11:46 [markd]
sometimes just 4 depending on how fast we go
20:13:01 [vinod]
not too bad. i took the bus down from here to visit him and it took 10 hrs (with stops)
20:13:09 [vinod]
won't do that again!
21:11:52 [vinod]
vinod has quit
22:18:39 [markd]
markd has quit
22:38:22 [ola]
ola has quit
23:29:43 [davb]
davb has quit
23:49:43 [til]
til has joined #openacs