0

Good day! I have a requirement to upload an image to Sybase DB as HEX of type image. But i’m not able to  do it through Mendix databaseconnector. is there anyway I can achieve this using databaseconnector  or any other solution?  The below is the procedure  declare @AL_CHANNEL_ID NUMERIC(2) declare @AS_USER_ID VARCHAR(8) declare @AS_MACHINE_NAME VARCHAR(40) declare @AL_API_CODE NUMERIC(4) declare @AL_COMP NUMERIC(4) declare @AL_CIF NUMERIC(8) declare @AL_AMOUNT NUMERIC(20,3) declare @AL_HEIGHT NUMERIC(5) declare @AL_WIDTH NUMERIC(5) declare @AS_FORMAT VARCHAR(3) declare @AO_IMAGE IMAGE declare @OL_ERROR_CODE NUMERIC(6) declare @OS_ERROR_DESC VARCHAR(250) select @AL_CHANNEL_ID = 1 select @AS_USER_ID = 'USER' select @AS_MACHINE_NAME = 'MACHINE' select @AL_API_CODE = 107 select @AL_COMP = 2 select @AL_CIF = 44778 select @AL_AMOUNT = 0         -------------- DEFAULT 0 AS UNLIMITED select @AL_HEIGHT = 100      ----PIXEL's select @AL_WIDTH = 185        ----PIXEL's select @AS_FORMAT = 'JPG'   ------------------------ JPG , BMP , GIF select @AO_IMAGE = 0xFFD8FFE000104A46494600010101006000600000FFDB0043000201010201010202020202020202030503030303030604040305070607070706070708090B0908080A0807070A0D0A0A0B0C0C0C0C07090E0F0D0C0E0B0C0C0CFFDB004301020202030303060303060C0807080C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0CFFC0001108006400B903012200021101031101FFC4001F0000010501010101010100000000000000000102030405060708090A0BFFC400B5100002010303020403050504040000017D01020300041105122131410613516107227114328191A1082342B1C11552D1F02433627282090A161718191A25262728292A3435363738393A434445464748494A535455565758595A636465666768696A737475767778797A838485868788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE1E2E3E4E5E6E7E8E9EAF1F2F3F4F5F6F7F8F9FAFFC4001F0100030101010101010101010000000000000102030405060708090A0BFFC400B51100020102040403040705040400010277000102031104052131061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A262728292A35363738393A434445464748494A535455565758595A636465666768696A737475767778797A82838485868788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE2E3E4E5E6E7E8E9EAF2F3F4F5F6F7F8F9FAFFDA000C03010002110311003F00FDD87D57C439C0D16CC81FF510FF00ED74A9A96BC572DA35A67FEC21FF00DAEB7A1732021800CB8C81CE38E9526DF7FD29E865C92EE73E354D7B23FE24D69FF830FF00ED748BA8EBAFB8C9A2DA1C74FF00898673F9C75D0EDF7FD293CBF7AA4D21F24BF98E78EA5ACA63FE2476FCFA5F8FFE2290EA7ACFCA7FB12024F5FF004F5E3FF1CAE8F67BD1B3DEA1C95F60E597F31C5F8AFC6F7DE15F0E6A5A8DDE8624B6D36D66BA9562BB5791D2342C5554A60B100800F04D739F0F34AD6FC2B7FA60BBD1AD9F56D5ADAEEF354906A21FFD2DE485DA257280BC485DD10919D90AE40EFB7F1A2D7FB5B48D3B491211FDB3AB5ADB3856219A25904D201FF0089FF02F5AFE22262F14F869F0016BE95188E3ADACE48FA1201FC2B684E308691F8AE67284AE9B64E979AC739D120FFC0E53FF00B2529BDD581E74543F4BD4C7EAB5B30C8651DC7F93520527B9AC2EBF94D96BB183F6DD5BFE808BFF008189FF00C4D1F6DD5BFE808BFF008189FF00C4D6F6D3EA68DA7D4D175D82C61A5EEAC739D1C2FF00DBE2F3F90A7AEA3AAC63074724FB5DA1FE75B3B4FA9A369F5345D760B18FFDABAAFF00D019F3FF005F69447ABEAC186ED18FFE05A56C6D3EA680A411CE69DD760B197FDB1AA7FD01DBFF00029290EAFA9804FF0063B16FFAFA4AD6A2828C91AC6A9819D1DB3FF5F494BFDB1AA7FD01DBFF000292B568A00CAFED8D53FE80EDFF00814947F6C6A9FF004076FF00C0A4AD5A280324EA9A9727FB1D89FF00AFA4A67F6C6ADFF405FF00C9B4AD9A280190C0B06EDB9F9B93EE7D69F4514005145140051451401C0F89ADE4BFF8D7E168546EB6D3ADEFF5399BBC73110DB42BF464B8B920FF00B0D5A5E32BA11F897C2D093F35CEA8EA9F55B3B873FA0AA3E1959354F8BBE2BBC6501208ECB4C88F52E23496627DBE7B923FED9D41E2D12EB3F1BBC09671644564BA96B32B0E9FBB852D4213EA4DE9383FF3CCFA56B286AA3D97FC13272BAF53BBB6E589EC47F53530E948AA178000FA0A5AC8D22ACAC148E4852738C50E7E53CF6AF2FF00DA23E26C9E0DF045A59D8DD5CDBF887C5F771E85A3795F3BA5CCE8EE64C67188A28E5949EB88580E6AE9C1CE4A2BA84A56573D3A193CD058306069F591E09D187873C3F67A70B8BDBA1616D15B896EE769EE25D88177C92312CF23632CC4924924939AD7A97BB430A28A290051451400514514005145140051451400514514008EE234666202A8C927800544350899B68662C06EC6D3D2A5906E46079C8F4CD79C78A3E16EADA4DF5CEB7E15D64699ACDDAC42E62BD496FAC6F0C6A55098B7EE47C7CA65421D86376EDAB8B8454A566EC4CA763D0E3BD8E5660AC495EBC1A53748182EE393D383EBFF00D7AF1BBAF8DBE3AF04DC8B7D57E11F88F5B5550AD7BE17D5F4DBBB6E3FE995DDC5B4EA4927811B9E392702A1F167ED47ABE83E1DD435383E11FC479934EB596F2592E5B4BB58A109196392F79BCFDDC7C88DF8D57D5AB39250B3F991EDE3ADD6C767F0AAF3ED3A66B17B34AA24BDD5AF2E509E0246B33451E4FA158837D0D66FC166FF0084BFC6FE21F1818E58ADB5429A56968E31BACAD1E5DB328C91B6596799C375653167A0AE5FC0BF0A3C6FE33F08E8DA578AEEED3C33A158D85BDBDE695A4DD35C5E6A0CA804A93DD615563761CAC4A1CE58799B59837B0E89A341A04315BDAC50C16D6EA228618D022448ABB55540E8028518E98515A559460DF77A134E2DA573529AD2853824E684977B30C1F97BE4106A9EADA8C7A6C52CD2EED91804EC059BAFA0AE594AC6E5B9A65481DCB6005273D31C75AF0AF0D696BF19BF6BCBED764225D07E15D91D274A182124D62ED03DF4CCA7F8A1B636D129C7CA6E2E475622BA9F8FBFB4759FC19F000BD82D5F51D6B559D34BD0B4E6531C9A95F48E238E3DA7044609DEEE32163491BB0057E16F872DBE01F80344D12FAEAEF55D4DD249F50BE86C259A5D635091BCCBBBC648558A996691DF180A8A76AE140037A6A54D394BAAB2FD4CA5352F751E8F68026E1EBC93DC9F5A9B70F5AA4BA92C68182C8FBD430E8A7E98620823D0814B73AD43631992E658ED907F1CAE114FD33D6B15CDD8D1C92D1977775F6A432051926B936F8D7E1E37D2DADBDEBEA375164341630497520C1C1C88D485FC48A82EBE25EAB7125CADB784B558E281772DCDFDDDADB4330F550B23CA00EFBA353E993C538C64F7139AB1D9AB86EF4A0E73ED58BE05F17C7E35D1FEDB0C1243189648812CAE926C764DE8CA48646DBB958755619C1CA8DA0319F7A1E8ECC7177570A28A290C28A28A0028A28A0028A28A004638527D05569732C455B90DDBD7DAAC4F9F21F04E769C6067B579C7C46866F15F8E7C3DE1B926D52DAC6EE1BDD4EE64B2BB96D4BADB9822588C90B2C8A4BDDC6FC10310383C1A4A8FB49D9BB1329B5B2B9DD2DB795B9BBE00E090547A71D3F0AE27E3DDE9B3F08DB69F1B1DDADEA765A705DA586D92653264770635901CF623D2B06DF4DF88DF0B6563A75CAFC43D14A9616FAADC259EAD6A001889275410DC2F3C3C815B8F9A46CE4727E28FDA4A2D5FE2F784AC356F0CF8EBC389A3C377AC5F4775A05C5E8591552DAD53CCB3F3E160ED7133A9563FF1ECC78AE9C360A5ED3F749CACB65B9954AF4D2FDE687D042308838DBB070371DA38F4AE4EF7E255D5E6A7AADA687A77F6BCBA341209DCCC208A4BB0995B4590E407CE37B72B18619249DA392B9F1FF89FE32DD0D33C2F61ACF8774190E2F35FD56CE4B1B978C8E52CADE40270FD7F7D3471AA820A97E31DFF00877C2B63E01F09C1A76976896F6964A1614405DB19C962704962DF31382493939A8F65ECDFEF7E27D3B15CDCCBDD764790597C54F899F0EFC436BAEF8EF53F06D8785F57BBB5B47B3B3B7791746DD04C7CC7BA2E372C93F931AB6C3F7D3214364759E25FDAAFC3F67A9DCD86952C5E21D56DA4F26582CA65586DB24F33DCBED862000C901DA438215188C55283E1378DFC782DEEBC57E31BCD2614505F44F0B471D9DACBC0F965BA911EE24C738314902F27E56E08ABE3AF85DE12F815E0BD475CD27C176FE20D797643656F22B5DDDEA77523AA41199652E541723739FBABB9BB576BA985A8E3ED959AD9474BFA9CF295549F2EA8F13D27E3ED8FC40F8ED1DF68B0EA3F18BC4DE1C862BF36FE179215D3E39A749634812EA574823B6B588B48FBE569669AEA070A7CA403D4FC1BFB53788BC64D6FA55E69DE13F0778A1B516D2E6B2D475617CD2CA91F99FBAF282AB6E5652A5DC6EC36012307B6F80DF05DBE0CFC327B39E65D77C4FA8BC9AAEB9A811E49D635398169E6C7FCB38CBE5235E91C611470A2B97D0BF6533A9FC2AB8D375C9EDD75BF15EB317883C5775648CA3549BCD495EDE373F3C702858E08C821C45103F7D9CD695B1385949C797456B5DEBF25B35F232A74EB249DB73625F115BEA9F12AE7C37AD78FF50B7D574EB28EFEE34DB04874CB578A4791149976B4C18185CE1654254A920865A25F1EFC2BF0D78A16D219EC355D7A719482DA19B58D42651DCAA2C92E3DCF1EA45759E06F83FE16F06E842C34EF0F6996968ACCE226B6DE4B31F998970589381D4E7017DABA8D3747B2D32D5A1B7B4B7B6898E4A45104527D70062B8DD783F853FBADF81D9ECEA3D5A382B3F1DF8ABC4B652C7A478486876E32219B5DB98E3DE80E03ADBDBB4AE015C102428C3386553902D45F089BC5D385F15EAB79ACDBC8A09D3602D67A7120E4978D0EF981C722791D4FF70577E235E3D4714A91ED7CE306B19E22CED1561AA7DC874DD2A2D2A158E2CE155507000014600000000E3A0000EC0559A28A86EFAB350A28A29005145140051451400514DF32977FD698361267CB6C75C57257FB1BE2EE86D9CB3E8FA811C751E758FF0088FCEBAB79308C7A902B99D66D5D3C77E1FBB049216EED481C0DAE88FF00CE014E0ED27E8CCEA2E65A1B929F9C83924F6C643707835E7BF0C166D7FE2DF8F3C41E6B490B4D69A0DB8C602C5689248D8F5266BB94E4705420EA0D76BE2AD7ECFC27E1FBED5B51B98ED34ED2EDDEFAEA793858218D4BBC87D95431FC2B96FD9BF41B9D0FE0CE8725F472C3A8EAE926B37D149F7ADEE2F246BA921FA44D298C7FB31AD0A56A6DBEB643A8D39A3D0A3FB8BF4A5A6A3108BC13C0A5DC7B8352B62C5A2937FD68DFF5A62BA168A4DFF5A37FD680B8B8A3149BFEB46FFAD01742D149BFEB46FF00AD01742D149BFEB46FFAD01742D149BFEB46FF00AD160E642D149BFEB46FFAD160E642D149BFEB46E3E8680E64733FF0B77C301883E23F0E823FEA270E7FF42A3FE16E7860F3FF00092F873FF0670FFF00155A3FF081687924E8BA5127AFFA247FE14BFF00081E863FE60DA57FE0247FE14DB27DF5B19BFF000B6FC30411FF00092F8739FF00A89C3FFC55735E3FF8A7E1E03489E0F126805ADB54B769366AB002232595B396E987AEDFFE104D13FE80FA5E7FEBD23FF0ACEF157C35D2353F0FDD5BC1A568D15CCF1948647B18DD6390FDC6231C80D838F6A70924F513E7B6A79E7ED1FF0013FC3BADFC3B5D063D73C3B771F8A750B5D16E17FB4612BF679A61F68070FF0077C813023FDAF635DDC5F15BC2F0A6C7F11F87D5D4F20EA70647FE3DE95C0DB5AE8DF13BE2B784AEB4CD374C4D234ED0DFC41708D6718749EF02C1641B8FF9E62FF70EC552BD3EDBC05A0CD106FEC5D298638CD9C79C761D2AEB72C69C60D6B722129B968451FC54F0E145235FD0882382350879FF00C7A94FC53F0E91CEBDA1FF00E0C21FFE2AAC0F873E1E382742D1893FF4E517FF001347FC2B9F0FFF00D00B46FF00C028BFF89ACAE5DA5B95BFE168F870FF00CC7F443FF6FF000FFF00154F4F88DA0CABB975DD1883E97B11FE46A61F0E7C3E3FE605A373FF004E517FF134D6F86BE1C7393A068A4FFD78C5FF00C4D34C2F53C880FC4FF0E2921BC41A2061C11F6F878FFC7A957E26F87A43B575FD1198F6FB7C47FAD4E3E1C7878003FB0746E3FE9CA2FF00E2683F0DFC3AC30741D14E7FE9C62FFE269F321DEA79117FC2C4D0FF00E83BA2FF00E0747FE340F887A19FF98E68C7E97B19FEB527FC2B3F0DFF00D0BFA27FE00C5FFC4D1FF0ACFC39FF0042FE89FF0080317FF1347320BD4F223FF8589A1E79D7345FFC0E8FFC697FE1626847FE639A313FF5FD1FF8D3FF00E159F86FFE85FD13FF000062FF00E26907C31F0D8E7FE11ED0F3FF005E117FF1347320BD4F21BFF0B0F421D75CD1BFF03631FD6947C43D04E7FE279A39C7A5EC67FAD29F863E1B3D7C3DA21FAD8C47FF0065A07C30F0D0CFFC53DA273FF4E317FF0013473215EA790DFF008589A17FD07746FF00C0E8FF00C68FF8589A11FF0098E68C4FFD7F47FE34EFF8561E1AFF00A17B43FF00C008BFF89A07C31F0D8E7FE11ED0F3FF005E117FF1347320BD4F21BFF0B0B43FFA0E68FF00F8191FF8D1FF000B07443FF31CD1BFF0363FFE2A9FFF000ACBC37FF42FE8BFF80317FF00134D3F0BFC34DC9F0EE864FBD8447FF65A3990EF53C841F10744271FDB7A3927B0BC8F9FD69DFF0009EE8FFF00415D37FF000322FF001A07C32F0D8C7FC53FA271FF004E317FF1347FC2B0F0D7FD0BDA27FE00C5FF00C4D1CC82F53C8DCA28A2A0B027009AABABC863D3DD81C328C83E840C8FE54514D6E852D8E77E1F7C2FD1BE185F6B2347B66B7FED9B9FB7DCEE72E4C8C5B2067A2E41381DD98F7AEAA3E4734514AB49B95D9953DC75145141B05145140051451400514514005145140051451400514514005145140051451401FFD9 select @OL_ERROR_CODE = NULL select @OS_ERROR_DESC = NULL execute P_API_CREATE_CIF_SIGN_KHCB @AL_CHANNEL_ID, @AS_USER_ID, @AS_MACHINE_NAME, @AL_API_CODE, @AL_COMP, @AL_CIF, @AL_AMOUNT, @AL_HEIGHT, @AL_WIDTH, @AS_FORMAT, @AO_IMAGE, @OL_ERROR_CODE out, @OS_ERROR_DESC out   Thanks in advance!

asked 2022-04-18

0 answers