oo4ole : Messages : 975-1004 of 1863

Messages: Simplify \| Expand (Group by Topic)		Author	Sort by Date

975	Don't set DBGrid1.datasource to the recordset of the ORADC1. It has to point to the ORADC1 itselfs. example: private sub form_load() master.connect...	Hans Noordhof kinetics@...	Feb 4, 2001 2:23 pm
976	If i did this, i get "type mismatch DBGrid1.DataSource was not handled" in Visual Interdev..I can set it in VB 6.0 but not in Visual Interdev. Is the data...	tam_huynh@...	Feb 6, 2001 8:01 pm
977	DBGrid is incompatible with ORADC. Try MS FlexGrid instead of DBGrid. ... From: tam_huynh@... <tam_huynh@...> To:...	Gennady gennadyb@...	Feb 6, 2001 10:06 pm
978	CREATE OR REPLACE PACKAGE InsertUser as PROCEDURE addUser(userName IN VARCHAR2, passwd IN VARCHAR2, defaultTbsp IN VARCHAR2, tempTbsp INVARCHAR2); END...	tam_huynh@...	Feb 6, 2001 11:21 pm
979	SAME ERROR!! ORADC1.Connect "username/psswd" 'Set the database name. ORADC1.DatabaseName = "alias" 'Set the record source. ORADC1.RecordSource = "select...	tam_huynh@...	Feb 6, 2001 11:50 pm
980	why don�t ypu try setting a blankspace after each 'IN' From: tam_huynh@... Reply-To: oo4ole@yahoogroups.com To: oo4ole@yahoogroups.com Subject:...	Juan Jose Cruz Orozco juanjose_cruz@...	Feb 7, 2001 12:30 am
981	i fixed it but i still get the same error message except now it's referring to my input parameters! ... ORA=06550 line 1, column 7 PLS-00201 Identifier 'm'...	tam_huynh@...	Feb 7, 2001 12:56 am
982	declare m varchar2(50); . . -- other variables declared here . begin InsertUser.addUser(m,df,default,temp); end;...	Mark Tomlinson marktoml@...	Feb 7, 2001 1:01 am
983	in order to test a SP in ORACLE you have to define a PL/SQL block... so.. if you're connected .. SQL> declare 2 var_name var_type; 3 var_name var type; 4...	Juan Jose Cruz Orozco juanjose_cruz@...	Feb 7, 2001 1:13 am
984	Ok, i have tested it in sqlplus and in my asp page and both say the same thing: 'ORA-04063 package body "SYSTEM.ADDUSER" has errors ORA- 06508:' ... CREATE OR...	tam_huynh@...	Feb 7, 2001 3:12 am
985	do a show errors After compilation in SQL*Plus to discover the error and line number....	Mark Tomlinson marktoml@...	Feb 7, 2001 11:51 am
986	errr... try: InsertUser.addUser('m','df','default','temp');...	Daemon@...	Feb 7, 2001 1:07 pm
987	Not sure exactly at what rev it cam in but at least in 8i you should use dynamic sql to execute ddl commands like create user: e.g. execute immediate ' CREATE...	Quinn Sinnott dbmuqs@...	Feb 7, 2001 1:36 pm
988	Ok, after further look into it, I realised that you can't use CREATE USER in a package. Use EXECUTE IMMEDIATE 'Create User ' \|\| userName \|\| '.... blah blah...	Daemon@...	Feb 7, 2001 1:39 pm
989	I am a OO4O novice. I am able to use VBA to retrieve and update records in an Oracle table. However, I am not sure how to insert records. Any assistance...	ecostantino@...	Feb 7, 2001 8:00 pm
990	Thanks for the info, i didn't realize about using dynamic SQL til today...Thanks for responding! ... CREATE USER in ... blah ... package has ... the ... ORA- ...	tam_huynh@...	Feb 8, 2001 1:40 am
991	1) Connection Public OraSession As Object Public myDatabase As Object Set OraSession = CreateObject("OracleInProcServer.XOraSession") Set myDatabase =...	Antonio Guadagnin antonioguadagnin@...	Feb 8, 2001 10:56 am
992	Hello, I fetch a the nextval from a sequece create as increment by 1. However whenever I fetch the nextval it returns a value that is incremented by 2. Anyone...	Gerrit-Jan Linker gjlinker@...	Feb 8, 2001 10:51 pm
993	This procedure compiles fine but when i tested it, comes back: ORA-06546 DLL STATEMENT EXECUTED IN AN ILLEGAL CONTEXT ORA-06512 "system.newuser", line 12 Can...	tam_huynh@...	Feb 8, 2001 11:27 pm
994	why don't you use DBMS_SQL ????? From: tam_huynh@... Reply-To: oo4ole@yahoogroups.com To: oo4ole@yahoogroups.com Subject: [oo4ole] ME AGAIN:...	Juan Jose Cruz Orozco juanjose_cruz@...	Feb 9, 2001 12:43 am
995	What's the difference? It should still give me the same result! ... means? ... ______________________________________________________________________ ... ...	tam_huynh@...	Feb 9, 2001 1:10 am
996	since the begining... let's see... what about if you put this into your SQLPLUS editor... CREATE or replace PROCEDURE newuser ( userName VARCHAR2, passwd...	Juan Jose Cruz Orozco juanjose_cruz@...	Feb 9, 2001 1:49 am
997	I'm just learning Oracle, so please bear with me..I did try dbms_sql way and the procedure compiles fine. I know i have admistrator privileges bc i can create...	tam_huynh@...	Feb 9, 2001 2:47 am
998	Hi i am using VB6 and Oracle8. I am not able to select rows from table which includes Blob Data Type. could any one let me know how do i proceed??? Many Thanx ...	Mahesh SethuraM@...	Feb 9, 2001 1:02 pm
999	Hi I need to Access Oracle Blob Data through ADO. Is that possible and if so please let me know Mahesh...	Mahesh SethuraM@...	Feb 9, 2001 1:06 pm
1000	What version of oo4o are you using? you will have to use min. version 8.x.3.2 of oo4o - Christian ... From: Mahesh [mailto:SethuraM@...] Sent: 9. februar...	Christian Linkhusen ckl@...	Feb 9, 2001 1:08 pm
1001	I haven't tried it, but what about using a variant for datatype, and get the data using field.GetChunk(size)? Look on the help online for ADO for examples on...	Daemon@...	Feb 9, 2001 1:12 pm
1002	I need to access it through ADO only. I don't want to use oracle objects. is that possible??? Thanx Mahesh...	Mahesh SethuraM@...	Feb 9, 2001 1:54 pm
1003	Look up GetChunk in the ADO help online...	Daemon@...	Feb 9, 2001 1:56 pm
1004	thanx for ur help. But During Select statement itself it is giving "DataType not supported" error. Regds Mahesh...	Mahesh Sethuraman SethuraM@...	Feb 9, 2001 2:00 pm

Yahoo! Groups Tips

Did you know...

Messages

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages